PostgreSQL: catalogs

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

pg_user
pg_catalog
pg_catalog.pg_class
pg_catalog.pg_tables
pg_catalog.pg_stat_archiver

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

• pg_stat, pg_stat_activity, pg_stat_statements, pg_stat_replication, pg_stat_io, pg_stat_archiver, pg_catalog
• pg_catalog, pg_catalog.age
• PostgreSQL: catalogs, PostgreSQL extensions

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