postgresql数据库查询所有索引详细信息，包括描述信息

把里边的public改成相应模式名（默认为public，可不改）

table_name改成对应表名称

SELECTA.SCHEMANAME,A.TABLENAME,A.INDEXNAME,A.TABLESPACE,A.INDEXDEF,B.AMNAME,C.INDEXRELID,C.INDNATTS,C.INDISUNIQUE,C.INDISPRIMARY,C.INDISCLUSTERED,D.DESCRIPTIONFROMPG_AM BLEFT JOIN PG_CLASS F ON B.OID = F.RELAMLEFT JOIN PG_STAT_ALL_INDEXES E ON F.OID = E.INDEXRELIDLEFT JOIN PG_INDEX C ON E.INDEXRELID = C.INDEXRELIDLEFT OUTER JOIN PG_DESCRIPTION D ON C.INDEXRELID = D.OBJOID,PG_INDEXES AWHEREA.SCHEMANAME = E.SCHEMANAME AND A.TABLENAME = E.RELNAME AND A.INDEXNAME = E.INDEXRELNAMEAND E.SCHEMANAME = 'public' AND E.RELNAME = 'table_name'