PostgreSQL: catalogs

From wikieduonline
Jump to navigation Jump to search

https://www.postgresql.org/docs/current/catalogs.html

pg_user
pg_catalog
pg_catalog.pg_class
pg_catalog.pg_tables

SELECT * FROM pg catalog.pg tables;


completePostgresql=> select nspname from pg_catalog.pg_namespace;
      nspname
--------------------
 pg_toast
 pg_catalog
 information_schema
 public
(4 rows)

Related[edit]

See also[edit]

  • https://dba.stackexchange.com/questions/40045/how-do-i-list-all-schemas-in-postgresql
  • Advertising: