【PgSQL】导出表结构为EXCEL

2023-12-14 22:02:24

详细SQL语句：
C.relname = ‘你的表名’ 直接输入表面即可

PgSQL 打印表结构语句

SELECT 
    C.relname AS "表名",
		CAST(obj_description(C.oid, 'pg_class') AS VARCHAR) AS "表名描述",
    A.attname AS "字段名",
		CASE 
        WHEN A.attnotnull = 'f' THEN '否'
        ELSE '是'
    END AS "是否为空",
    concat_ws ( '', T.typname, SUBSTRING ( format_type ( A.atttypid, A.atttypmod ) FROM '\(.*\)' ) ) AS "数据类型",
    d.description AS "注释" 
FROM
    pg_class C,
    pg_attribute A,
    pg_type T,
    pg_description d 
WHERE
    C.relname = '你的表名' 
    AND A.attrelid = C.oid 
    AND A.atttypid = T.oid 
    AND d.objoid = A.attrelid 
    AND d.objsubid = A.attnum 
ORDER BY
    C.relname DESC,
    A.attnum ASC;

效果如下

在这里插入图片描述

导出自己想要的格式

在这里插入图片描述

文章来源:https://blog.csdn.net/zfx1101804091/article/details/135003579
本文来自互联网用户投稿，该文观点仅代表作者本人，不代表本站立场。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。