PostgreSQL 获取含有某字段的 table

前端之家收集整理的这篇文章主要介绍了PostgreSQL 获取含有某字段的 table前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

需求:找到所有的含有 n_jbfy 的表名

SELECT c.relname,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 aty_class AS c,aty_attribute AS a WHERE a.attrelid = c.oid AND a.attnum > 0 AND a.attname = 'n_jbfy'

原文链接:https://www.f2er.com/postgresql/195341.html

猜你在找的Postgre SQL相关文章