导出PGSQL 表结构信息导出到excel 中 (数据库设计说明书)

1. 获取数据库表的结构信息(SQL命令)

   SELECT
       c.relname AS "表名",
       obj_description(c.oid, 'pg_class') AS "表注释",
       obj_description(c.oid, 'pg_class') AS "表备注",
       a.attname AS "字段名",
       format_type(a.atttypid, a.atttypmod) AS "字段类型",
       CASE 
           WHEN a.attlen > 0 THEN a.attlen 
           ELSE NULL 
       END AS "长度/精度",
       CASE 
           WHEN a.attnotnull THEN 'NO' 
           ELSE 'YES' 
       END AS "是否为空",
       pg_get_expr(d.adbin, d.adrelid) AS "默认值",
       col_description(a.attrelid, a.attnum) AS "字段注释"
   FROM
       pg_class c
   JOIN
       pg_attribute a ON a.attrelid = c.oid
   LEFT JOIN
       pg_attrdef d ON d.adrelid = a.attrelid AND d.adnum = a.attnum
   WHERE
       c.relkind = 'r' -- 只查询普通表
       AND c.relname NOT LIKE 'pg_%' -- 排除系统表
       AND c.relname NOT LIKE 'sql_%' -- 排除系统表
       AND a.attnum > 0 -- 排除系统字段
       AND a.attisdropped = false -- 排除已删除的字段 (去除掉........pg.xx........格式字段)
   ORDER BY
       c.relname, a.attnum; -- 按表名和字段顺序排序
   

2. 将数据结构以excel格式进行导出(navicat 收费版本)

3. 整理数据格式

4. 合并单元格

   参考: https://jingyan.baidu.com/article/c1a3101e76189fde656deb93.html

5. 增加序号(不规则合并单元格中添加序号)

   参考: https://healthnews.sohu.com/a/878615932_122021433

备注:

参考文档 (将数据库中的表结构导出到excel中（写数据库设计说明书）): https://blog.csdn.net/qq_35587839/article/details/109166529