Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
test
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 -- nulls first LIMIT 10
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
cpana
test
proj
Timestamps in PostgreSQL
book suggestion
Query integer in text field - Seemingly doesn't work as expected
Recursive inefficiency
pokemo
tic tac toe
SQL - Unpivot Table
Please log in to post a comment.