1
/* **********************************
2
* Administrative functions
3
* ********************************* */
5
/* generic file access functions (genfile.c) */
7
CREATE FUNCTION pg_file_stat(text) RETURNS record
8
AS 'MODULE_PATHNAME', 'pg_file_stat'
9
LANGUAGE C VOLATILE STRICT;
11
CREATE FUNCTION pg_file_length(text) RETURNS bigint
12
AS 'SELECT len FROM pg_file_stat($1) AS s(len int8, c timestamp, a timestamp, m timestamp, i bool)'
13
LANGUAGE SQL VOLATILE STRICT;
15
CREATE FUNCTION pg_file_read(text, bigint, bigint) RETURNS text
16
AS 'MODULE_PATHNAME', 'pg_file_read'
17
LANGUAGE C VOLATILE STRICT;
19
CREATE FUNCTION pg_file_write(text, text, bool) RETURNS bigint
20
AS 'MODULE_PATHNAME', 'pg_file_write'
21
LANGUAGE C VOLATILE STRICT;
23
CREATE FUNCTION pg_file_rename(text, text, text) RETURNS bool
24
AS 'MODULE_PATHNAME', 'pg_file_rename'
27
CREATE FUNCTION pg_file_unlink(text) RETURNS bool
28
AS 'MODULE_PATHNAME', 'pg_file_unlink'
29
LANGUAGE C VOLATILE STRICT;
31
CREATE FUNCTION pg_file_rename(text, text) RETURNS bool
32
AS 'SELECT pg_file_rename($1, $2, NULL); '
33
LANGUAGE SQL VOLATILE STRICT;
35
CREATE FUNCTION pg_dir_ls(text, bool) RETURNS setof text
36
AS 'MODULE_PATHNAME', 'pg_dir_ls'
37
LANGUAGE C VOLATILE STRICT;
40
/* Miscellaneous functions (misc.c) */
42
CREATE FUNCTION pg_reload_conf() RETURNS int4
43
AS 'MODULE_PATHNAME', 'pg_reload_conf'
44
LANGUAGE C STABLE STRICT;
47
CREATE FUNCTION pg_logfile_rotate() RETURNS bool
48
AS 'MODULE_PATHNAME', 'pg_logfile_rotate'
49
LANGUAGE C STABLE STRICT;
52
CREATE FUNCTION pg_postmaster_starttime() RETURNS timestamp
53
AS 'MODULE_PATHNAME', 'pg_postmaster_starttime'
54
LANGUAGE C VOLATILE STRICT;
56
CREATE FUNCTION pg_logdir_ls() RETURNS setof record
57
AS 'MODULE_PATHNAME', 'pg_logdir_ls'
58
LANGUAGE C VOLATILE STRICT;
60
CREATE VIEW pg_logdir_ls AS
62
FROM pg_logdir_ls() AS A
63
(filetime timestamp, filename text);