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
| (9 intermediate revisions by 3 users not shown) | |||
| Line 3: | Line 3: | ||
[[pg_user]] | [[pg_user]] | ||
[[pg_catalog]] | [[pg_catalog]] | ||
| + | [[pg_catalog.pg_class]] | ||
| + | [[pg_catalog]].[[pg_tables]] | ||
| + | |||
| + | [[SELECT * FROM pg catalog.pg tables;]] | ||
* Show/List [[schema]]s: <code>select [[nspname]] from [[pg_catalog]].pg_namespace;</code><ref>https://dba.stackexchange.com/questions/40045/how-do-i-list-all-schemas-in-postgresql</ref> | * Show/List [[schema]]s: <code>select [[nspname]] from [[pg_catalog]].pg_namespace;</code><ref>https://dba.stackexchange.com/questions/40045/how-do-i-list-all-schemas-in-postgresql</ref> | ||
| + | |||
| + | |||
| + | completePostgresql=> select nspname from pg_catalog.pg_namespace; | ||
| + | nspname | ||
| + | -------------------- | ||
| + | [[pg_toast]] | ||
| + | [[pg_catalog]] | ||
| + | [[information_schema]] | ||
| + | [[public]] | ||
| + | (4 rows) | ||
== Related == | == Related == | ||
* [[Schemas]] | * [[Schemas]] | ||
| − | + | * <code>[[information_schema]]</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_schemaALTER USER prometheus SET SEARCH_PATH TO prometheus,pg_catalog;*\dx
See also[edit]
Advertising:
