If you have 8.1.x you can do something like this:
SELECT pg_size_pretty(database_size(''));
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
On 7/7/06, Benjamin Krajmalnik <[EMAIL PROTECTED]> wrote:
Is there a query which can be issued which will return the size of adatabase?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 in
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
---
