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)?