Pg数据库导出表结构

SELECT a.attnum,a.attname AS field,t.typname AS type,a.attlen AS length,a .atttypmod AS lengthvar,a.attnotnull AS notnull,c.relname
from pg_class c,pg_attribute a,pg_type t 
where  a.attnum>0 and a.attrelid=c.oid and a.atttypid=t.oid and c.relname in(SELECT   relname FROM   pg_tables  a, pg_class b  
WHERE     
a.tablename = b.relname  
and a.tablename   NOT   LIKE   'pg%'    
AND a.tablename NOT LIKE 'sql_%'  
)
ORDER BY c.relname,a.attnum

仅供参考