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.COLUMNS
where
    table_name = 'cddem_parsinghistory'
order by ordinal_position;