contrib/adminpack/adminpack.sql.in

   1 /* $PostgreSQL$ */
   2
   3 /* ***********************************************
   4  * Administrative functions for PostgreSQL
   5  * *********************************************** */
   6
   7 /* generic file access functions */
   8
   9 CREATE OR REPLACE FUNCTION pg_catalog.pg_file_write(text, text, bool)
  10 RETURNS bigint
  11 AS 'MODULE_PATHNAME', 'pg_file_write'
  12 LANGUAGE C VOLATILE STRICT;
  13
  14 CREATE OR REPLACE FUNCTION pg_catalog.pg_file_rename(text, text, text)
  15 RETURNS bool
  16 AS 'MODULE_PATHNAME', 'pg_file_rename'
  17 LANGUAGE C VOLATILE;
  18
  19 CREATE OR REPLACE FUNCTION pg_catalog.pg_file_rename(text, text)
  20 RETURNS bool
  21 AS 'SELECT pg_catalog.pg_file_rename($1, $2, NULL::pg_catalog.text);'
  22 LANGUAGE SQL VOLATILE STRICT;
  23
  24 CREATE OR REPLACE FUNCTION pg_catalog.pg_file_unlink(text)
  25 RETURNS bool
  26 AS 'MODULE_PATHNAME', 'pg_file_unlink'
  27 LANGUAGE C VOLATILE STRICT;
  28
  29 CREATE OR REPLACE FUNCTION pg_catalog.pg_logdir_ls()
  30 RETURNS setof record
  31 AS 'MODULE_PATHNAME', 'pg_logdir_ls'
  32 LANGUAGE C VOLATILE STRICT;
  33
  34
  35 /* Renaming of existing backend functions for pgAdmin compatibility */
  36
  37 CREATE OR REPLACE FUNCTION pg_catalog.pg_file_read(text, bigint, bigint)
  38 RETURNS text
  39 AS 'pg_read_file'
  40 LANGUAGE INTERNAL VOLATILE STRICT;
  41
  42 CREATE OR REPLACE FUNCTION pg_catalog.pg_file_length(text)
  43 RETURNS bigint
  44 AS 'SELECT size FROM pg_catalog.pg_stat_file($1)'
  45 LANGUAGE SQL VOLATILE STRICT;
  46
  47 CREATE OR REPLACE FUNCTION pg_catalog.pg_logfile_rotate()
  48 RETURNS int4
  49 AS 'pg_rotate_logfile'
  50 LANGUAGE INTERNAL VOLATILE STRICT;