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
Watch video Tutorial 36-PostgreSQL system catalogs schema (System information tables) | pg_catalog online without registration, duration hours minute second in high quality. This video was added by user mynotesoracledba 31 January 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,763 once and liked it 18 people.