SELECT
PS.RELNAME AS TABLE_NAME
,PA.ATTNAME AS COLUMN_NAME
,PD.DESCRIPTION AS COLUMN_COMMENT
FROM
PG_STAT_ALL_TABLES PS
,PG_DESCRIPTION PD
,PG_ATTRIBUTE PA
WHERE
PD.OBJSUBID <> 0
AND PS.RELID = PD.OBJOID
AND PD.OBJOID = PA.ATTRELID
AND PD.OBJSUBID = PA.ATTNUM
AND PS.SCHEMANAME ILIKE 'public' -- INPUT: 스키마
AND PS.RELNAME ILIKE 'BZ_USER' -- INPUT: 테이블
ORDER BY PS.RELNAME, PD.OBJSUBID
;