PostgresSql 数据库获取所有表的索引信息

PostgresSql 数据库获取所有表的索引信息

-- 查询全部有关信息
select
a.schemaname,
a.tablename,
a.indexname,
a.tablespace,
a.indexdef,
b.amname,
c.indexrelid,
c.indnatts,
c.indisunique,
c.indisprimary,
c.indisclustered,
d.description
from pg_am b
left join pg_class f on b.oid = f.relam
left join pg_stat_all_indexes e on f.oid = e.indexrelid
left join pg_index c on e.indexrelid = c.indexrelid
left outer join pg_description d on c.indexrelid = d.objoid, pg_indexes a
where a.schemaname = e.schemaname and a.tablename = e.relname and a.indexname = e.indexrelname
order by a.tablename

-- 按表进行索引信息分类

select a.tablename,string_agg(a.indexdef,';
')from pg_indexes a group by a.tablename order by a.tablename

 select a.tablename,string_agg(a.indexdef,';')from pg_indexes a group by a.tablename order by a.tablename

其他信息，PostgresSql 中查询库中所有的表以及表中字段、主键、唯一、外键

PostgresSql 中查询库中所有的表以及表中字段、主键、唯一、外键，查询某一个表中的所有字段查询某一个表中的所有字段