schedoc

pig build pkg pg_schedoc;		# build rpm/deb

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

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

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

CREATE EXTENSION schedoc CASCADE; -- requires ddl_historization

CREATE EXTENSION schedoc CASCADE;
SELECT schedoc_start();

COMMENT ON COLUMN my_table.id IS '{"status": "private"}';
COMMENT ON COLUMN my_table.email IS '{"status": "public"}';
COMMENT ON COLUMN my_table.name IS '{"status": "internal"}';

SELECT * FROM schedoc_column_comments;