SELECT B.ATTNAME AS COLUMN_NAME,
C.TYPNAME AS DATA_TYPE,
B.ATTTYPMOD-4 AS DATA_LENGTH,
D.DESCRIPTION
FROM PG_CLASS A, PG_ATTRIBUTE B, PG_TYPE C, PG_DESCRIPTION D
WHERE A.RELNAME = 'content' --이부분에 테이블 이름 넣어 주면됨
AND B.ATTNUM > 0
AND B.ATTRELID = A.OID
AND B.ATTTYPID = C.OID
AND A.OID = D.OBJOID
AND B.ATTNUM = D.OBJSUBID
ORDER BY B.ATTNUM;
아래과 같은 결과가 나타난다.
"seq";"int4";-5;"일련번호"
"code";"varchar";12;"코드"
"indx";"int4";-5;"카테고리"
"title";"varchar";200;"제목"
"content";"text";-5;"내용"
"file";"varchar";300;"첨부파일"
"moddate";"varchar";14;"변경일시"
"moduserid";"varchar";50;"변경자"
"hookone";"varchar";500;"후크로서 필요에 따라서 다른 사용을 가진다"
"hooktwo";"varchar";1000;"후크로서나중에필요에의했임"
|