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

0 vote151 views2 answers
Script all indexes in a database
SQL
0 vote145 views1 answer
Postgres jsonb array push new element
SQL
0 vote161 views1 answer
Postgres grep entire database
SQL
1 vote121 views1 answer
Strict in postgres SQL
SQL
1 vote188 views1 answer
Sql server read uncommitted
SQL
6 votes155 views3 answers
Mysql create database utf8
SQL
16 votes154 views1 answer
CTE statement sql server
SQL
0 vote161 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
0 vote143 views2 answers
Postgres default user
SQL
0 vote157 views1 answer
Import excel to sql
SQL