If you have 8.1.x you can do something like this:
SELECT pg_size_pretty(database_size('<database name>'));
example:
SELECT pg_size_pretty(database_size('testdb'));
If you have another version of postgres, check out the dbsize contrib module.
On Fri, 7 Jul 2006, Benjamin Krajmalnik wrote:
Is there a query which can be issued which will return the size of a
database?
I see that in pgadmin you can get the values on a per table manner.
I have looced at the pg_catalog schema, but to be truthful I cannot
figure out how to get that information.
TIA,
Benjamin
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
--
Jeff Frost, Owner <jeff@xxxxxxxxxxxxxxxxxxxxxx>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
