728x90 postgresql #comment #코멘트1 PostgreSQL 쿼리 -- 테이블 명세 조회SELECT c.relname AS table_name, pg_catalog.obj_description(c.oid, 'pg_class') AS table_comment, a.attname AS column_name, col_description(a.attrelid, a.attnum) AS column_comment, CASE WHEN pg_catalog.format_type(a.atttypid, a.atttypmod) LIKE 'timestamp%' THEN 'timestamp'-- WHEN pg_catalog.format_type(a.atttypid, a.atttypmod) LIKE 'character varying%' THEN '' .. 2021. 12. 10. 이전 1 다음 728x90