假设postgres有数据库testdb
在testdb下执行下列sql语句,得到所有表的信息
select * from information_schema.columns
where table_schema='public' and table_name<>'pg_stat_statements';
在testdb下执行下列sql语句,得到所有表的列名
select column_name from information_schema.columns
where table_schema='public' and table_name<>'pg_stat_statements';
在testdb下执行下列sql语句,得到表"table"的列名
select column_name from information_schema.columns
where table_schema='public' and table_name='table';
补充:PostgreSql数据库查询表信息/列信息(列ID/列名/数据类型/长度/精度/是否可以为null/默认值/是否自增/是否是主键/列描述)
查询表信息(表名/表描述)
select a.relname as name , b.description as value from pg_class a
left join (select * from pg_description where objsubid &