PgSQL常用脚本 及函数
1.查找数据库表字段及注释脚本
SELECT
col_description ( A.attrelid, A.attnum ) AS COMMENT,
format_type ( A.atttypid, A.atttypmod ) AS TYPE,
A.attname AS NAME,
A.attnotnull AS NOTNULL
FROM
pg_class AS C,
pg_attribute AS A
WHERE
C.relname = 'tableName'
AND A.att
原创
2022-05-18 09:32:54 ·
413 阅读 ·
0 评论