List all indexes in postgres database

indexes.sql

SELECT indexname FROM pg_indexes;

I think you mean "select" instead of "selext".

🙉

This is the #1 Google result for "list all indexes postgres" 🐱

@dmcmulle but still has a typo 😃

Btw, if anyone wants to specify a schema: select indexname from pg_indexes where schemaname = 'public';

FIXED:

SELECT indexname FROM pg_indexes;

FIXED:

runekaagaard/postgres@d22492d

FIXED:

runekaagaard/postgres@d22492d

👍 for taking the time to do this

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