Postgresql 컬럼 및 코멘트 조회

컬럼 조회select table_name, column_name, udt_name as "type", character_maximum_length as length , (case when is_nullable = 'NO' then 'N' else '' end) as "nullable"from INFORMATION_SCHEMA.COLUMNSwhere table_name = '테이블명'order by ordinal_position; 컬럼 코멘트 조회SELECT PS.RELNAME AS TABLE_NAME ,PA.ATTNAME AS COLUMN_NAME ,PD.DESCRIPTION AS COLUMN_COMM..

2025.03.14