diff options
| author | Heikki Linnakangas <heikki.linnakangas@iki.fi> | 2008-05-02 10:16:16 +0000 |
|---|---|---|
| committer | Heikki Linnakangas <heikki.linnakangas@iki.fi> | 2008-05-02 10:16:16 +0000 |
| commit | 72e1d28afd686e19b8e7f32817e927448123fb78 (patch) | |
| tree | a7119f06a8f878cd8795bdcc6c57bddb07c2bb35 | |
| parent | 6f093f3825d13bc5ad41a64bf2f5251c5b62395b (diff) | |
| download | postgresql-72e1d28afd686e19b8e7f32817e927448123fb78.tar.gz postgresql-72e1d28afd686e19b8e7f32817e927448123fb78.zip | |
Show relation size in verbose (e.g. \d+) output.
Dickson S. Guedes
| -rw-r--r-- | src/bin/psql/describe.c | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/src/bin/psql/describe.c b/src/bin/psql/describe.c index 57f238b44b9..c0de7a6d84d 100644 --- a/src/bin/psql/describe.c +++ b/src/bin/psql/describe.c @@ -3,7 +3,7 @@ * * Copyright (c) 2000-2008, PostgreSQL Global Development Group * - * $PostgreSQL: pgsql/src/bin/psql/describe.c,v 1.167 2008/04/14 15:04:20 alvherre Exp $ + * $PostgreSQL: pgsql/src/bin/psql/describe.c,v 1.168 2008/05/02 10:16:16 heikki Exp $ */ #include "postgres_fe.h" #include "describe.h" @@ -1766,9 +1766,14 @@ listTables(const char *tabtypes, const char *pattern, bool verbose) gettext_noop("Table")); if (verbose) + { + appendPQExpBuffer(&buf, + ",\n pg_catalog.pg_size_pretty(pg_catalog.pg_relation_size(c.oid)) as \"%s\"", + gettext_noop("Size")); appendPQExpBuffer(&buf, ",\n pg_catalog.obj_description(c.oid, 'pg_class') as \"%s\"", gettext_noop("Description")); + } appendPQExpBuffer(&buf, "\nFROM pg_catalog.pg_class c" |