【PostgreSQL】テーブルのカラム名と論理名（コメント）の一覧を取得

code:カラム名と論理名の一覧を取得.sql

SELECT

isc.column_name

, pd.description

FROM

pg_stat_user_tables AS psut

LEFT JOIN information_schema.columns AS isc

ON psut.relname = isc.table_name

AND psut.schemaname = isc.table_schema

LEFT JOIN pg_description AS pd

ON psut.relid = pd.objoid

AND pd.objsubid = isc.ordinal_position

WHERE

psut.schemaname = current_schema()

AND psut.relname = 'テーブル名'

ORDER BY

isc.ordinal_position;