Postgresql 获取表结构

 select Field.attnum,Field.attname AS field,pg_type.typname AS type,Field.attlen AS length,Field.attnotnull AS notnull,pg_attrdef.adsrc AS default,Field.comment as comment
 from
(select pg_attribute.*,col_description(pg_attribute.attrelid,pg_attribute.attnum) as comment from pg_class right join pg_attribute on pg_class.oid=pg_attribute.attrelid
where pg_class.relname='" . $tableName . "' and pg_attribute.attnum>0 and pg_attribute.atttypid>0 ) Field left join pg_type on Field.atttypid= pg_type.oid
left join pg_attrdef on Field.attrelid=pg_attrdef.adrelid and Field.attnum=pg_attrdef.adnum
left join pg_constraint on Field.attrelid=pg_constraint.conrelid and pg_constraint.conname=Field.attname

转载于:https://my.oschina.net/u/1447903/blog/783215