유리세계

-- 테이블 컬럼정보 조회하기
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 PS.SCHEMANAME = (SELECT SCHEMANAME
                       FROM PG_STAT_USER_TABLES
                       WHERE RELNAME = '#{TABLE_NAME}')
  AND PS.RELNAME  = '#{TABLE_NAME}'
  AND PS.RELID   = PD.OBJOID
  AND PD.OBJSUBID <> 0
  AND PD.OBJOID    = PA.ATTRELID
  AND PD.OBJSUBID  = PA.ATTNUM
ORDER BY PS.RELNAME, PD.OBJSUBID​

-- 테이블 정보 조회하기
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 OBJ_DESCRIPTION(C.OID) LIKE '#{TABLE_COMMENT}'