Answers for "select indexes of a table in postgres"

query for all indexes in table postgres

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

Posted by: Guest on October-25-2021

Code answers related to "select indexes of a table in postgres"