SELECT
cc.relname,
aa.attname,
dd.description
FROM
pg_attribute aa
LEFT JOIN pg_class AS cc ON aa.attrelid = cc.oid
LEFT JOIN pg_description AS dd ON dd.objoid = cc.oid
WHERE
dd.description IS NULL
SQL:查询数据库中哪些数据表的字段没有注释
最新推荐文章于 2024-04-28 22:44:07 发布