获取所有库名
SELECTdatname FROMpg_database WHEREdatistemplate = FALSE
获取表名
SELECTtablename FROMpg_tables WHEREschemaname = 'public'
获取字段名
SELECT A.attname AS 字段名,format_type ( A.atttypid, A.atttypmod ) AS 类型,A.attnotnull AS 不是 NULL col_description ( A.attrelid, A.attnum ) AS 注释,FROMpg_class AS C,pg_attribute AS A WHERE-- relname 需要查询的表名C.relname = 'data_api' AND A.attrelid = C.oid AND A.attnum >0