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‘postgreSQL 获得某表的字段信息
原文：http://blog.csdn.net/u011598529/article/details/44116319
