https://wiki.pedromussato.com/index.php?action=history&feed=atom&title=List_databases_on_PostgreSQL_instance 2026-06-07T03:51:26Z Revision history for this page on the wiki MediaWiki 1.42.3 https://wiki.pedromussato.com/index.php?title=List_databases_on_PostgreSQL_instance&diff=230&oldid=prev 2025-02-03T10:25:43Z

<p>Created page with &quot;=== Query === SELECT datname FROM pg_database; === &quot;Describe&quot; === SELECT column_name, data_type, is_nullable FROM information_schema.columns WHERE table_name = &#039;pg_database&#039;; === column_name, data_type, is_nullable === oid|oid|NO datname|name|NO datdba|oid|NO encoding|integer|NO datlocprovider|&quot;char&quot;|NO datistemplate|boolean|NO datallowconn|boolean|NO datconnlimit|integer|NO datfrozenxid|xid|NO datminmxid|xid|NO dattablespace|oid|NO datcollate|text|NO da...&quot;</p> <p><b>New page</b></p><div>=== Query ===<br /> SELECT datname FROM pg_database;<br /> <br /> === &quot;Describe&quot; ===<br /> SELECT column_name, data_type, is_nullable FROM information_schema.columns WHERE table_name = &#039;pg_database&#039;;<br /> <br /> === column_name, data_type, is_nullable ===<br /> oid|oid|NO<br /> datname|name|NO<br /> datdba|oid|NO<br /> encoding|integer|NO<br /> datlocprovider|&quot;char&quot;|NO<br /> datistemplate|boolean|NO<br /> datallowconn|boolean|NO<br /> datconnlimit|integer|NO<br /> datfrozenxid|xid|NO<br /> datminmxid|xid|NO<br /> dattablespace|oid|NO<br /> datcollate|text|NO<br /> datctype|text|NO<br /> daticulocale|text|YES<br /> daticurules|text|YES<br /> datcollversion|text|YES<br /> datacl|ARRAY|YES</div>

413vhcu1lq0463ob