Machiel Richards pisze:

                Due to security restrictions I 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 ;