{"repo":"aquameta/meta","free":true,"listed":false,"github":"https://github.com/aquameta/meta","clone":"git clone https://github.com/aquameta/meta.git","description":"PostgreSQL Extension: More friendly system catalog for PostgreSQL","language":"PLpgSQL","stars":24,"topics":["postgresql","postgresql-extension","pg-catalog","information-schema","meta","catalog"],"license":"BSD-2-Clause","category":"databases-storage","readme_excerpt":"Meta: Simplified System Catalog for PostgreSQL ============================================== Overview System catalogs are great, because they provide a data-centric view into the database's structure. PostgreSQL has two system catalogs, pg catalog and information schema , but each have some drawbacks. pg catalog mirrors PostgreSQL's internal structure, and centers around oid , object identifiers that aren't intended for \"above the hood\" developers to know or care about. information schema is part of the SQL standard, and is filled with many views and columns that don't match PostgreSQL's terminology or features. The goals with meta is to provide an \"above the hood\" system catalog for PostgreSQL that is normalized and uses common names for views and columns. Features: - Meta System catalog: 30 views (full list) that, under the hood, query and synthesize pg catalog and information schema - Meta-identifiers: A set of composite types that encapsulate variables necessary to identify PostgreSQL objects (tables, columns, casts, types, etc.) by name, and serve as \"soft\" primary keys to the views above. See meta-identifiers for more. - Catalog triggers: Optional meta triggers extension, which adds INSERT/UPDATE triggers on the catalog's views. These triggers make it possible to do DDL statements (e.g. CREATE TABLE ... ) with an DML statement (e.g. insert into meta.table (name) values('foo')) , similar to a schema diff and migration tool but with a data-centric approach. Status: - The","default_branch":null,"files":null,"tree":[],"storefront":"/r/aquameta","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/aquameta/meta/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}