List all indexes in postgres database

indexes.sql

SELECT indexname FROM pg_indexes;

You can also type \di

You can also type \di

👍 👍 👍 It also shows you additional info that way. On the other hand, if you use select * from pg_indexes; you also get to see the index definitions.

@runekaagaard is it possible to make the parser handle both versions?

-- select indexes of tables in schema "public" --
select * from pg_indexes where schemaname = 'public'; 

The table has columns schemaname, tablename, indexname, tablespace, and SQL query of creation in indexdef.

Excluding pg_catalog may be a more useful approach if you are looking for some particular indices:

SELECT indexname FROM pg_indexes WHERE schemaname!='pg_catalog'

Wow, didn't realise this was getting so much attention. I don't think I'd been getting emails about gists until this week – perhaps its a new GitHub thing. Anyway, fixed :)