Skip to main content

Postgres show indexes

SELECT -- AND tablename = 'something'

tablename,
indexname,
indexdef
FROM
pg_indexes
WHERE
schemaname = 'public'
ORDER BY
tablename,
indexname;