https://wiki.pedromussato.com/index.php?action=history&feed=atom&title=%22Describe%22_a_table_in_PostgreSQL 2026-04-13T09:09:25Z Revision history for this page on the wiki MediaWiki 1.42.3 https://wiki.pedromussato.com/index.php?title=%22Describe%22_a_table_in_PostgreSQL&diff=232&oldid=prev 2025-02-03T10:28:23Z

<p>Created page with &quot;=== Query === SELECT column_name, data_type, is_nullable FROM information_schema.columns WHERE table_name = &#039;TABLE NAME HERE&#039;; === Example === SELECT column_name, data_type, is_nullable FROM information_schema.columns WHERE table_name = &#039;pg_database&#039;; 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 dattablespac...&quot;</p> <p><b>New page</b></p><div>=== Query ===<br /> SELECT column_name, data_type, is_nullable FROM information_schema.columns WHERE table_name = &#039;TABLE NAME HERE&#039;;<br /> <br /> === Example ===<br /> SELECT column_name, data_type, is_nullable FROM information_schema.columns WHERE table_name = &#039;pg_database&#039;;<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