postgres.git / summary / log / commit / refs
commit ee80f043bc9b92dbbb1ff9577c3c601746124092
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
Date: Mon Jul 14 22:04:52 2014 +0000
psql: Show tablespace size in \db+
FabrÃzio de Royes Mello
src/bin/psql/describe.c | 5 +++++
1 file changed, 5 insertions(+)
diff --git a/src/bin/psql/describe.c b/src/bin/psql/describe.c
index 951b7ee3cd3..282cd432a27 100644
--- a/src/bin/psql/describe.c
+++ b/src/bin/psql/describe.c
@@ -176,6 +176,11 @@ describeTablespaces(const char *pattern, bool verbose)
",\n spcoptions AS \"%s\"",
gettext_noop("Options"));
+ if (verbose && pset.sversion >= 90200)
+ appendPQExpBuffer(&buf,
+ ",\n pg_catalog.pg_size_pretty(pg_catalog.pg_tablespace_size(oid)) AS \"%s\"",
+ gettext_noop("Size"));
+
if (verbose && pset.sversion >= 80200)
appendPQExpBuffer(&buf,
",\n pg_catalog.shobj_description(oid, 'pg_tablespace') AS \"%s\"",
[parent: 346d7be184a6]