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

11 votes108 views1 answer
How to get ddl for materialized view
SQL
0 vote100 views1 answer
Sql server check whether column has same equal values
SQL
0 vote66 views1 answer
Oracle sql replace string in clob
SQL
0 vote86 views1 answer
Clear query cache sql server
SQL
0 vote233 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL
11 votes131 views2 answers
Set default column value sql
SQL
0 vote109 views1 answer
Power query datetime to date
SQL
-1 vote109 views2 answers
First letter capital in mysql query
SQL
4 votes100 views2 answers
Truncate oracle
SQL
2 votes97 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL