On 7/7/06, Benjamin Krajmalnik <kraj@xxxxxxxxxxx> 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
select datname, pg_database_size(datname) from pg_database;
This assumes your are running 8.x (might be 8.1.x).
This assumes your are running 8.x (might be 8.1.x).
chris