Query INFORMATION_SCHEMA for list of indexes

Asked Sep 05 '15 at 23:41

Active Sep 05 '15 at 23:41

Viewed 19 times

How does one query INFORMATION_SCHEMA in a standards-compliant database such as Postgres to obtain a list of all indexes in one database/catalog?

asked Sep 05 '15 at 23:41

Basil Bourque

This Answer by Bill Karwin said No. He explains indexes are an implementation-detail rather than a standard feature. So, not listed in INFORMATION_SCHEMA. – Basil Bourque Sep 06 '15 at 00:20

0 Answers0