0

Question as above. Is there a query I can run to find the schemas that are for system use? Or is my terminology wrong and I should be looking for something else in the documentation to find a list of schemas that are created by the system by default?

New contributor
Priyank is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
1
  • 1
    u looking for SELECT schema_name FROM information_schema.schemata WHERE schema_owner = 'postgres'; ?
    – Kin Shah
    2 days ago

1 Answer 1

1

You won't find it in one spot in the documentation, but here is a complete list:

schema name description
information_schema Metadata views as described by the SQL standard
pg_catalog System tables, views and functions (the catalog)
pg_toast Schema for overflow tables for large columns
pg_temp_* Schemas for temporary tables
pg_toast_temp_* Schemas for overflow tables for temporary tables

The * stands for a number: temporary tables for different sessions get different numbers. Note that all temporary objects can be referenced via the schema name pg_temp, so you could count that as a system schema as well.

Your Answer

Priyank is a new contributor. Be nice, and check out our Code of Conduct.

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.