Answers for "show all indexes postgres"

SQL
0

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
0

Get all index postgres

-- This will also return use the hidden index that automatically created by primary key and unique....
SELECT relname, relkind
FROM pg_class
WHERE relkind = 'i';
Posted by: Guest on January-03-2022

Code answers related to "SQL"

Browse Popular Code Answers by Language