postgresql 컬럼, 코멘트 조회

테이블 컬럼 정보

select c.relname, a.attrelid as "tableoid",
a.attname as "colname",
a.attnum as "columnoid",
(SELECT col_description(a.attrelid, a.attnum)) AS COMMENT
from pg_catalog.pg_class c
inner join pg_catalog.pg_attribute a on a.attrelid = c.oid
where c.relname = '테이블명'
and a.attnum > 0
and a.attisdropped is false
and pg_catalog.pg_table_is_visible(c.oid)
order by a.attrelid, a.attnum

 

테이블 코멘트 정보

SELECT n.nspname, c.relname, obj_description(c.oid)
FROM pg_catalog.pg_class c inner join pg_catalog.pg_namespace n on c.relnamespace=n.oid
WHERE c.relkind = 'r'
and nspname = '데이터베이스'
and relname = '테이블'