Documenting Your PostgreSQL Data Warehouse

postgres.sql

create table orders(id int);

comment on table orders is 'This table holds all customer orders!';

select description from pg_description
join pg_class on pg_description.objoid = pg_class.oid
where relname = 'orders';
┌───────────────────────────────────────┐
│               description             │
├───────────────────────────────────────┤
│ This table holds all customer orders! │
└───────────────────────────────────────┘