김프로&임테크

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 = 'public' AND PS.RELNAME = 'tb_menu' ORDER BY PS.RELNAME, PD.OBJSUBID RELNAME = '테이블명'

IT/Postgresql 2022. 5. 9. 17:38