·
PostgreSQLでテーブルの列を取得するクエリ
SELECT
att.attnum AS NUM,
att.attname AS COL_NAME,
typ.typname AS COL_TYPE,
com.description AS COL_COMMENT
FROM
pg_class cls
LEFT JOIN pg_attribute att ON cls.oid=att.attrelid
LEFT JOIN pg_type typ ON att.atttypid=typ.oid
LEFT JOIN pg_description com ON att.attrelid = com.objoid
AND att.attnum = com.objsubid
WHERE
att.attnum > 0
AND cls.relname = 't_hogehoge'
ORDER BY
att.attnum