postgre テーブルの列の一覧

SELECT
att.attname, tbl.relname
from
pg_attribute att, pg_class tbl
where
att.attrelid = tbl.oid