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@frostconsultingllc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954