https://develop-me-z.tistory.com/6 PostgreSQL | 테이블/컬럼 정보조회 SQL - 테이블 comment 조회 SELECT PS.RELNAME AS TABLE_NAME ,PD.DESCRIPTION AS TABLE_COMMENT FROM PG_STAT_USER_TABLES PS ,PG_DESCRIPTION PD WHERE PS.RELNAME = '테이블명' AND PS.RELID = PD.OBJOID AND PD.OBJSUBID = 0 ; - 테이블 columns 조회 select co develop-me-z.tistory.com 컬럼 정보 조회 SELECT TABLE_NAME, column_name, character_maximum_length, data_type FRO..