'DATABASE/Postgresql'에 해당되는 글 1건
- 2014.02.05 :: postgresql 컬럼 조회, 컬럼 코멘트 조회
--컬럼 코멘트 조회
select c.relname, a.attrelid as "tableoid",
a.attname as "colname",
a.attnum as "columnoid",
(SELECT col_description(a.attrelid, a.attnum)) AS COMMENT
from
pg_catalog.pg_class c
inner join pg_catalog.pg_attribute a on a.attrelid = c.oid
where
c.relname = '테이블명'
and a.attnum > 0
and a.attisdropped is false
and pg_catalog.pg_table_is_visible(c.oid)
order by a.attrelid, a.attnum
--컬럼 조회
select table_name, column_name, data_type, character_maximum_length , character_octet_length , udt_name
from information_schema.columns where table_name='테이블명'
order by ordinal_position
--테이블 코멘트 조회
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 nspname = 'public'
and relname = '테이블명'