How to list indexes created for a table in postgres

Could you tell me how to check which indexes are created for any table in postgresql?

+5
source share
2 answers

The pg_indexes view provides access to useful information about each index in the database, for example.

select * from pg_indexes where tablename not like 'pg%'; 
+8
source

if you are in psql then:

 \d tablename 

show indexes, foreign keys and links ...

+5
source

All Articles