PostgreSQL: catalogs

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;

• Show/List schemas: select nspname from pg_catalog.pg_namespace;

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

Related

• Schemas
• information_schema
• ALTER USER prometheus SET SEARCH_PATH TO prometheus,pg_catalog;*
• \dx

See also

• PostgreSQL: catalogs, PostgreSQL extensions

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