Answers for "sql check all index postgresql"

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

list all indexes postgres

select * from pg_indexes
where schemaname like '<schema-name>' and tablename like '<table-name>'

Posted by: Guest on October-25-2021

Code answers related to "sql check all index postgresql"