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

1 vote141 views1 answer
How to between in sql
SQL
0 vote161 views1 answer
Mysql group by range
SQL
0 vote165 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
0 vote148 views1 answer
Drop all tables db2
SQL
3 votes211 views2 answers
Mysql user permission database
SQL
0 vote167 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
23 votes141 views6 answers
How to create table in sql
SQL
1 vote244 views1 answer
Primary key reset in SQL database
SQL
0 vote182 views1 answer
Oracle sql date winter time
SQL
6 votes1.3K views1 answer
Sql select second max
SQL