postgreSQL 获得某表的字段信息

 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'