はてなブックマーク

SELECT relname as "テーブル名", pd.description as "テーブルコメント", colname as "列名", tbl.description as "コメント", CASE WHEN size IS NULL THEN datatype -- サイズ情報が取得できた場合は付加 ELSE datatype || ' (' || size || ')' END AS "データ型", CASE -- NOT NULL情報 と DEFAULT情報をマージ WHEN "notnull" IS NOT NULL AND "default" IS NOT NULL THEN "notnull" || ' ' || "default" -- ELSE COALESCE("notnull", "default") END AS "属性" FROM ( SELECT cl