From e908131810a259ecd3ff12f76d3a676dc56ec97c Mon Sep 17 00:00:00 2001 From: =?utf8?q?C=C3=A9dric=20Villemain?= Date: Tue, 8 Mar 2011 23:05:50 +0100 Subject: [PATCH] Add a function pgsysconf_pretty() --- pgfincore.sql.in | 17 +++++++++++++++++ uninstall_pgfincore.sql.in | 1 + 2 files changed, 18 insertions(+) diff --git a/pgfincore.sql.in b/pgfincore.sql.in index 5af6e76..e87dba5 100644 --- a/pgfincore.sql.in +++ b/pgfincore.sql.in @@ -7,6 +7,22 @@ RETURNS record AS 'MODULE_PATHNAME' LANGUAGE C; +CREATE OR REPLACE FUNCTION +pgsysconf_pretty(OUT block_size text, + OUT free_memory text) +RETURNS record +AS ' +select pg_size_pretty(block_size) as block_size, + pg_size_pretty(block_free * block_size) as free_memory +from pgsysconf()' +LANGUAGE SQL; + + + + + + + CREATE OR REPLACE FUNCTION pgfincore(IN regclass, IN text, @@ -98,3 +114,4 @@ pgfadv_random(IN regclass, RETURNS setof record AS 'SELECT pgfincore($1, ''main'', 60)' LANGUAGE SQL; + diff --git a/uninstall_pgfincore.sql.in b/uninstall_pgfincore.sql.in index e70a340..2f5686a 100644 --- a/uninstall_pgfincore.sql.in +++ b/uninstall_pgfincore.sql.in @@ -1,6 +1,7 @@ SET search_path = public; DROP FUNCTION pgsysconf(); +DROP FUNCTION pgsysconf_pretty(); DROP FUNCTION pgfincore(regclass, text, int); -- 2.39.5