adminpack.sql

来自「PostgreSQL 8.2中增加了很多企业用户所需要的功能和性能上的提高,其开」· SQL 代码 · 共 42 行

/* ***********************************************
 * Administrative functions for PostgreSQL 
 * *********************************************** */

/* generic file access functions */

CREATE FUNCTION pg_catalog.pg_file_write(text, text, bool) RETURNS bigint
   AS '$libdir/adminpack', 'pg_file_write'
	LANGUAGE C VOLATILE STRICT;

CREATE FUNCTION pg_catalog.pg_file_rename(text, text, text) RETURNS bool
   AS '$libdir/adminpack', 'pg_file_rename'
	LANGUAGE C VOLATILE;

CREATE FUNCTION pg_catalog.pg_file_rename(text, text) RETURNS bool
   AS 'SELECT pg_file_rename($1, $2, NULL); '
	LANGUAGE SQL VOLATILE STRICT;

CREATE FUNCTION pg_catalog.pg_file_unlink(text) RETURNS bool
   AS '$libdir/adminpack', 'pg_file_unlink'
	LANGUAGE C VOLATILE STRICT;

CREATE FUNCTION pg_catalog.pg_logdir_ls() RETURNS setof record
   AS '$libdir/adminpack', 'pg_logdir_ls'
	LANGUAGE C VOLATILE STRICT;


/* Renaming of existing backend functions for pgAdmin compatibility */

CREATE FUNCTION pg_catalog.pg_file_read(text, bigint, bigint) RETURNS text
   AS 'pg_read_file'
	LANGUAGE INTERNAL VOLATILE STRICT;

CREATE FUNCTION pg_catalog.pg_file_length(text) RETURNS bigint
   AS 'SELECT size FROM pg_stat_file($1)'
    LANGUAGE SQL VOLATILE STRICT;

CREATE FUNCTION pg_catalog.pg_logfile_rotate() RETURNS int4
  AS 'pg_rotate_logfile'
   LANGUAGE INTERNAL VOLATILE STRICT;