Difference between revisions of "PostgreSQL: catalogs"

From wikieduonline
Jump to navigation Jump to search
Line 3: Line 3:
 
  [[pg_user]]
 
  [[pg_user]]
 
  [[pg_catalog]]
 
  [[pg_catalog]]
 +
[[pg_catalog]].[[pg_tables]]
  
 
* Show/List [[schema]]s: <code>select [[nspname]] from [[pg_catalog]].pg_namespace;</code><ref>https://dba.stackexchange.com/questions/40045/how-do-i-list-all-schemas-in-postgresql</ref>
 
* Show/List [[schema]]s: <code>select [[nspname]] from [[pg_catalog]].pg_namespace;</code><ref>https://dba.stackexchange.com/questions/40045/how-do-i-list-all-schemas-in-postgresql</ref>

Revision as of 12:47, 12 May 2022

Advertising: