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 vote295 views2 answers
How to combine diff colmun value using group by postgres
SQL
0 vote303 views1 answer
Print mysql
SQL
7 votes281 views2 answers
N highest salary in sql
SQL
0 vote292 views1 answer
Sql select rows with different values in one column
SQL
0 vote336 views1 answer
Fetching data from mysqldb
SQL
0 vote292 views1 answer
Sql delete where x or y or z
SQL
1 vote332 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL
12 votes326 views6 answers
Distinct in sql server
SQL
3 votes307 views1 answer
Apex set debug level
SQL
0 vote236 views1 answer
Oracle last user logon
SQL