Tutorial 36-PostgreSQL system catalogs schema (System information tables) | pg_catalog

What is system catalogs schema in posrgresql? 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 #pg_catalog #postgresql #systemcatalogschema