Databases list

DB Name DB Owner Encoding Template? Allow connections? Connection limits Last system OID Frozen XID Tablespace name Size Configuration ACL
benchs guillaume UTF8 Off On -1 11510 379 pg_default 18 MB
logs guillaume UTF8 Off On -1 11510 379 pg_default 4968 kB
middleoffice postgres UTF8 Off On -1 11510 379 pg_default 187 MB
moduleo guillaume UTF8 Off On -1 11510 379 pg_default 4295 kB
pagila guillaume UTF8 Off On -1 11510 379 pg_default 11 MB
postgres guillaume UTF8 Off On -1 11510 379 pg_default 4223 kB
template0 guillaume UTF8 On Off -1 11510 379 pg_default 4144 kB {=c/guillaume,guillaume=CTc/guillaume}
template1 guillaume UTF8 On On -1 11510 379 pg_default 4223 kB {=c/guillaume,guillaume=CTc/guillaume}
tests guillaume UTF8 Off On -1 11510 379 pg_default 144 MB

SELECT datname, rolname AS dba, pg_catalog.pg_encoding_to_char(encoding) AS encoding, datistemplate, datallowconn, datconnlimit, datlastsysoid, datfrozenxid, spcname as tablespace, pg_size_pretty(pg_database_size(datname)) AS size, datconfig, datacl FROM pg_database, pg_roles, pg_tablespace WHERE datdba = pg_roles.oid AND dattablespace = pg_tablespace.oid ORDER BY datname