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

获取所有库名

SELECT
	datname 
FROM
	pg_database 
WHERE
	datistemplate = FALSE

获取表名

SELECT
	tablename 
FROM
	pg_tables 
WHERE
	schemaname = 'public'

获取字段名

SELECT 
	A.attname AS 字段名,
	format_type ( A.atttypid, A.atttypmod ) AS 类型,
	A.attnotnull AS 不是 NULL col_description ( A.attrelid, A.attnum ) AS 注释,
FROM
	pg_class AS C,
	pg_attribute AS A 
WHERE
	-- relname 需要查询的表名
	C.relname = 'data_api' 
	AND A.attrelid = C.oid 
	AND A.attnum >0