Re: Calculating database sizes using a script - Mailing list pgsql-novice

Machiel Richards pisze:


                  Due to security
restrictionsI 
am not yet
able to use pgadmin / pgphpadmin and need to manually calculate this
using ‘SELECT
pg_size_pretty(pg_database_size(''));’
                  Is there a way of
running this in a script
for each database in the instance without having to manually type in
each
database name?


select
pg_size_pretty(pg_database_size(datname)), datname from
pg_catalog.pg_database ;