PG相关

查询系统目录获取元数据

SELECT
column_name,
data_type,
is_nullable,
column_default,
pg_catalog.col_description(('inventory'::regclass)::oid, ordinal_position) AS comment
FROM
information_schema.columns
WHERE
table_name = 'inventory';