select
c.relname AS "表名",
cast(obj_description(relfilenode,'pg_class') as varchar) AS "表名描述",
a.attnum AS "序號",
a.attname AS "列名",
concat_ws('',t.typname,SUBSTRING(format_type(a.atttypid,a.atttypmod) from '\(.*\)')) as "字段類型",
d.description AS "備注"
from pg_class c
LEFT JOIN pg_attribute a on a.attrelid = c.oid
LEFT JOIN pg_type t on a.atttypid = t.oid
LEFT JOIN pg_description d on a.atttypid = t.oid and d.objsubid=a.attnum
LEFT JOIN pg_namespace ns on ns.oid = c.relnamespace
-- where c.relname = '表名'
where a.attnum>0 and c.relkind = 'r' and ns.nspname = 'public'
ORDER BY c.relname DESC,a.attnum ASC
2. 拷貝查詢結(jié)構(gòu)到excel
2.1 拷貝查詢結(jié)果到excel晨川，然后全選數(shù)據(jù)宣脉，插入表格鳞青。
2.2 為每一列增加標題骤菠。
image.png
參考文檔
本文作者： seawish
版權(quán)聲明： 本博客所有文章除特別聲明外瞄沙，均采用 CC BY-NC-SA 3.0 許可協(xié)議己沛。轉(zhuǎn)載請注明出處！
