Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Get a list of the indexes and their definitions for a given table, in Postgres
SELECT tablename,
indexname,
indexdef
FROM pg_indexes
WHERE tablename = '$$table_name$$'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.