meta

pig build pkg pg_meta;		# build rpm/deb

pig repo add pgsql -u   # add both repo and update cache

pig install pg_meta;		# install via package name, for the active PG version
pig install meta;		# install by extension name, for the current active PG version

pig install meta -v 18;   # install for PG 18
pig install meta -v 17;   # install for PG 17
pig install meta -v 16;   # install for PG 16
pig install meta -v 15;   # install for PG 15
pig install meta -v 14;   # install for PG 14

CREATE EXTENSION meta;

-- List all tables
SELECT * FROM meta.table;

-- List all columns
SELECT * FROM meta.column;

-- List all views
SELECT * FROM meta.view;

-- List schemas
SELECT * FROM meta.schema;

-- List functions
SELECT * FROM meta.function;

-- List extensions
SELECT * FROM meta.extension;

-- List triggers
SELECT * FROM meta.trigger;

-- List foreign keys
SELECT * FROM meta.foreign_key;

-- List constraints
SELECT * FROM meta.constraint_check;
SELECT * FROM meta.constraint_unique;

-- List types
SELECT * FROM meta.type;

-- List roles
SELECT * FROM meta.role;

-- List sequences
SELECT * FROM meta.sequence;

-- List operators
SELECT * FROM meta.operator;

-- List policies
SELECT * FROM meta.policy;

-- Create a table via INSERT
INSERT INTO meta.table (schema_name, name) VALUES ('public', 'foo');