List databases on PostgreSQL instance

From PedrosBrainDump
Revision as of 10:25, 3 February 2025 by 413vhcu1lq0463ob (talk | contribs) (Created page with "=== Query === SELECT datname FROM pg_database; === "Describe" === SELECT column_name, data_type, is_nullable FROM information_schema.columns WHERE table_name = 'pg_database'; === column_name, data_type, is_nullable === oid|oid|NO datname|name|NO datdba|oid|NO encoding|integer|NO datlocprovider|"char"|NO datistemplate|boolean|NO datallowconn|boolean|NO datconnlimit|integer|NO datfrozenxid|xid|NO datminmxid|xid|NO dattablespace|oid|NO datcollate|text|NO da...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Query

SELECT datname FROM pg_database;

"Describe"

SELECT column_name, data_type, is_nullable FROM information_schema.columns WHERE table_name = 'pg_database';

column_name, data_type, is_nullable

oid|oid|NO
datname|name|NO
datdba|oid|NO
encoding|integer|NO
datlocprovider|"char"|NO
datistemplate|boolean|NO
datallowconn|boolean|NO
datconnlimit|integer|NO
datfrozenxid|xid|NO
datminmxid|xid|NO
dattablespace|oid|NO
datcollate|text|NO
datctype|text|NO
daticulocale|text|YES
daticurules|text|YES
datcollversion|text|YES
datacl|ARRAY|YES