Get all index postgres

List all indexes postgres

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

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';

Similar codes

10 votes198 views5 answers
Create table mysql query
SQL
2 votes199 views2 answers
Enable foreign key checks postgres
SQL
0 vote156 views1 answer
Big query add table rows to another table
SQL
0 vote224 views1 answer
How to get parent and child record in single query using sql
SQL
3 votes251 views1 answer
Sql several or
SQL
0 vote203 views1 answer
Sql select most frequent value in column
SQL
5 votes195 views2 answers
Sql create tabel with primary key auto_increment code
SQL
0 vote211 views2 answers
Mysql dump structure only
SQL
0 vote213 views2 answers
How to get the date from datetime in mysql
SQL
0 vote262 views1 answer
SQL joins in python
SQL