Postgresql - how to list indexes on a table that is partitioned?

by Thiago Sayão   Last Updated August 13, 2019 20:06 PM

This command works for non-partitioned tables:

select * from pg_indexes

But for partitioned tables, it does not list the original index, but the indexes that postgresql created for each partition.

To drop an index, I need the original name.

How do I list all indexes on a table that is partitioned (with the name it was created)?

Related Questions

Storing and querying rolling data in PostgreSQL

Updated April 22, 2015 00:02 AM

Slow queries on billions-rows-table // index used

Updated April 08, 2015 20:02 PM