数据库
SELECT * FROM "pg_database";
表信息
SELECT "schemaname","tablename","tableowner","hasindexes","hasrules",obj_description(relfilenode,'pg_class') AS "description" FROM "pg_tables" AS tb INNER JOIN "pg_class" cs ON cs.relname = tb.tablename WHERE tablename NOT LIKE 'pg%' AND tablename NOT LIKE 'sql_%' ORDER BY tablename;
字段信息
select "table_catalog","table_schema","column_name","ordinal_position","udt_name","character_maximum_length" from "information_schema"."columns" where "table_schema"='public' and "table_name"='TableName' order by "ordinal_position";
