postgresql中查询COMMENT注释的语句

 

tb_car表中DDL语句中有COMMENT

COMMENT ON COLUMN public.tb_car.car_id IS '主键'; COMMENT ON COLUMN public.tb_car.car_index_code IS '车辆编码'; COMMENT ON COLUMN public.tb_car.plate_no IS '车牌号码';

用如下语句查询

SELECT col.table_name, col.column_name, col.ordinal_position AS o, d.description FROM information_schema.columns col          JOIN pg_class c ON c.relname = col.table_name          LEFT JOIN pg_description d ON d.objoid = c.oid AND d.objsubid = col.ordinal_position WHERE col.table_schema = 'public' and col.table_name = 'tb_car'