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


Updated September 20, 2017 14:06 PM

Updated April 22, 2015 00:02 AM

Updated September 13, 2017 15:06 PM

Updated April 08, 2015 20:02 PM

Updated August 22, 2017 15:06 PM