PostgreSQL 获取所有库名 表名 字段名

获取所有库名

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