GP - Database List
Generating the report on the list of database
SELECT
d.oid AS "Database OID",
d.datname AS "Database Name",
r.rolname AS "Database Owner",
pg_catalog.pg_encoding_to_char(d.encoding) AS "Database Encoding",
d.datallowconn AS "Connections Allowed",
d.datconnlimit AS "Connection Limit",
pg_size_pretty(pg_database_size(d.datname)) AS "Database Size"
FROM
pg_catalog.pg_database d ,
pg_catalog.pg_roles r
WHERE
d.datdba=r.oid
ORDER BY 2 ;
NOTE: This SQL can ran from any Database
Comments
Post a Comment