aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMagnus Hagander <magnus@hagander.net>2014-01-26 18:11:15 +0100
committerMagnus Hagander <magnus@hagander.net>2014-01-26 18:42:08 +0100
commitcae10ca27e5d478353b9b053073e5f2a1cf97659 (patch)
tree94f0022aeacb677dd41dfb5a8aec0a20b8ea69d0
parentcec8394b5ccd32259e446f963690dd4784646b4d (diff)
downloadpostgresql-cae10ca27e5d478353b9b053073e5f2a1cf97659.tar.gz
postgresql-cae10ca27e5d478353b9b053073e5f2a1cf97659.zip
Include tablespace options in verbose output of \db
-rw-r--r--src/bin/psql/describe.c5
1 files changed, 5 insertions, 0 deletions
diff --git a/src/bin/psql/describe.c b/src/bin/psql/describe.c
index 0d4b151679a..43f1a1c12dd 100644
--- a/src/bin/psql/describe.c
+++ b/src/bin/psql/describe.c
@@ -176,6 +176,11 @@ describeTablespaces(const char *pattern, bool verbose)
",\n pg_catalog.shobj_description(oid, 'pg_tablespace') AS \"%s\"",
gettext_noop("Description"));
+ if (verbose && pset.sversion >= 90000)
+ appendPQExpBuffer(&buf,
+ ",\n spcoptions AS \"%s\"",
+ gettext_noop("Options"));
+
appendPQExpBufferStr(&buf,
"\nFROM pg_catalog.pg_tablespace\n");