pgsql导出表字段Excel -- Navicat

1.表字段查询sql

SELECT
 A.attnum AS "序号",
 C.relname AS "表名",
 A.attname AS "字段名",-- 字段名
 t.typname as "字段类型",    --字段类型
 NULLIF(information_schema._pg_char_max_length(A.atttypid, A.atttypmod), -1) AS "字符串最大长度",  -- 字符串最大长度
 col_description ( A.attrelid, A.attnum ) AS "字段备注",   -- 字段备注
 A.attnotnull AS "是否非空" ,  -- 是否非空
 A.atthasdef AS "是否存在默认值",    --是否存在默认值
 obj_description(c.relfilenode) AS "表名描述"
-- cast(obj_description(relfilenode,'pg_class') as varchar) AS "表名描述"
FROM
	pg_class AS C,
	pg_attribute AS A ,
	pg_type as T
WHERE
	C.relname IN (
		select tablename from pg_tables where schemaname = 'public'
	)
	AND 
	A.attrelid = C.oid 
	AND A.atttypid= T.oid
	AND A.attnum > 0
	AND NOT A.attisdropped
	
	ORDER BY C.relname, A.attnum ;
	

查询结果，导出

参考：pgsql 常用查询汇总(查询数据表字段)