- The postgres system is automatically creates and maintains the schema as pg_catalog in each database
- This schema is known as system catalog schema because it towards information about tables,columns ,other objects and internal bookkeeping information
- PostgreSQL's system catalogs are regular tables. You can drop and recreate the tables, add columns, insert ,update values, and severely mess up your system that way.
- it is also effectively part of the search_path
RK
Posted on
What is a pg_catalog in postgresql?
For further actions, you may consider blocking this person and/or reporting abuse
Top comments (0)