Difference between revisions of "PostgreSQL: catalogs"
Jump to navigation
Jump to search
↑ https://dba.stackexchange.com/questions/40045/how-do-i-list-all-schemas-in-postgresql
| Line 27: | Line 27: | ||
== See also == | == See also == | ||
| − | * {{PostgreSQL}} | + | * {{PostgreSQL catalogs}} |
[[Category:PostgreSQL]] | [[Category:PostgreSQL]] | ||
Latest revision as of 15:19, 19 December 2024
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;[1]
completePostgresql=> select nspname from pg_catalog.pg_namespace;
nspname
--------------------
pg_toast
pg_catalog
information_schema
public
(4 rows)
Related[edit]
- Schemas
information_schemaALTER USER prometheus SET SEARCH_PATH TO prometheus,pg_catalog;*\dx
See also[edit]
Advertising:
