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 c.relname = 't_mses' 原文链接：https://www.f2er.com/postgresql/195339.html