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
(One intermediate revision by the same user not shown) | |||
Line 24: | Line 24: | ||
* <code>[[information_schema]]</code> | * <code>[[information_schema]]</code> | ||
* <code>[[ALTER]] USER prometheus [[SET]] SEARCH_PATH TO prometheus,pg_catalog;* </code> | * <code>[[ALTER]] USER prometheus [[SET]] SEARCH_PATH TO prometheus,pg_catalog;* </code> | ||
+ | * <code>[[\dx]]</code> | ||
== 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_schema
ALTER USER prometheus SET SEARCH_PATH TO prometheus,pg_catalog;*
\dx
See also[edit]
Advertising: