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 vote208 views1 answer
Postgres execute multiple sql file from command line
SQL
0 vote161 views1 answer
Sql server split string and insert into table select
SQL
1 vote168 views1 answer
MySQL AND Operator
SQL
21 votes169 views1 answer
Cheatsheet for sql
SQL
0 vote175 views1 answer
Sp in sql server
SQL
0 vote182 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
0 vote167 views2 answers
Mysql updating multiple column values from array variable
SQL
0 vote162 views1 answer
Object Information
SQL
0 vote166 views1 answer
How to print mysql query of codeigniter query builder
SQL
8 votes124 views2 answers
Alter column name in mssql
SQL