获取表字段信息

SELECT a.attname 字段名 ,format_type(a.atttypid, a.atttypmod) 字段类型,d.adsrc 缺省值,a.attnotnull 非空,f.description 描述 FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum LEFT JOIN pg_description f ON a.attrelid = f.objoid AND a.attnum = f.objsubid WHERE a.attrelid = '_employee'::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum