■ 테이블 컬럼 정보 조회하기

------------------------------------------------------------------------------------------------------------------------

 

SELECT *

FROM   INFORMATION_SCHEMA.COLUMNS

WHERE  TABLE_SCHEMA = 'public'

ORDER BY

    TABLE_CATALOG    ASC

   ,TABLE_SCHEMA     ASC

   ,TABLE_NAME       ASC

   ,ORDINAL_POSITION ASC

   ,COLUMN_NAME      ASC

 

------------------------------------------------------------------------------------------------------------------------

Posted by 사용자 icodebroker
TAG