How to list all the indexes along with their type (BTREE, BRIN, HASH etc...)

16 votes

3 answers

11992 views

postgresql postgresql-9.6 system-tables catalogs

                          I'm querying to the system catalog in Postgresql 9.6.4

Getting a result set of tables and their indexes is straight forward,what I'm missing is the index type (BTREE, BRIN, etc..) I can't seem to find the type of index anywhere in the system catalogs.

How can I query the catalogs to get a list of indexes along with their type?

Asked by maxTrialfire (1194 rep)

Sep 26, 2017, 05:13 PM
Last activity: Jul 17, 2021, 08:02 PM

How to list all the indexes along with their type (BTREE, BRIN, HASH etc...)

Related Questions