Brad Nicholson wrote:
On Mon, 2008-06-23 at 10:50 -0700, Reynolds, Gregory A wrote:
In past versions there was a contrib/dbsize command that would tell
you how much storage space was being taken by a table. Is that is
still a supported feature in 8.3, and if so what is the syntax or
where is the documentation on how to use it?
There are a series of functions in the database core that will tell you
this now.
http://www.postgresql.org/docs/8.3/interactive/functions-admin.html
This is what I use: SELECT
pg_size_pretty(pg_database_size(current_database()));
Found it a while back on pg-general.
-salman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
