postgresql表结构查询sql

SELECT

t1.attnum as &#34;序号&#34;,<br/>
t1.attname as &#34;字段名&#34;,<br/>
concat_ws ( &#39;&#39;, t2.typname, SUBSTRING ( format_type ( t1.atttypid, t1.atttypmod ) FROM &#39;\(.*\)&#39; ) ) AS &#34;数据类型&#34; ,<br/>
t3.description AS &#34;注释&#34;<br/>
-- (case t1.attnotnull WHEN &#39;f&#39; THEN &#39;否&#39; ELSE &#39;是&#39; end )AS &#34;必填&#34;,<br/>
-- t1.attnotnull as &#34;不是null&#34;<br/>

FROM

pg_attribute t1<br/>
LEFT JOIN pg_type t2 ON t1.atttypid = t2.oid<br/>
LEFT JOIN pg_description t3 ON t3.objoid = t1.attrelid  AND t3.objsubid = t1.attnum<br/>
LEFT JOIN pg_class t4 ON t1.attrelid = t4.oid<br/>

WHERE

t1.attnum &gt; 0<br/>
AND t4.relname = &#39;order&#39;; -- 数据库名称<br/>