You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
12 lines
449 B
12 lines
449 B
SELECT d.datname AS Name, pg_catalog.pg_get_userbyid(d.datdba) AS Owner, |
|
CASE WHEN pg_catalog.has_database_privilege(d.datname, 'CONNECT') |
|
THEN pg_catalog.pg_size_pretty(pg_catalog.pg_database_size(d.datname)) |
|
ELSE 'No Access' |
|
END AS SIZE |
|
FROM pg_catalog.pg_database d |
|
ORDER BY |
|
CASE WHEN pg_catalog.has_database_privilege(d.datname, 'CONNECT') |
|
THEN pg_catalog.pg_database_size(d.datname) |
|
ELSE NULL |
|
END DESC |
|
LIMIT 20; |