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

7 votes148 views1 answer
Alter sequence set current value oracle
SQL
0 vote144 views1 answer
Sql min
SQL
1 vote117 views3 answers
Grant syntax in sql
SQL
0 vote136 views1 answer
Flask sqlalchemy. commit does not save changes
SQL
0 vote141 views1 answer
Virtuoso sql query tutorial
SQL
1 vote141 views1 answer
Mysql count multiple columns in one query
SQL
1 vote133 views1 answer
Oracle first row
SQL
1 vote137 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
10 votes140 views4 answers
Primary key sql
SQL
0 vote148 views1 answer
Set engine to innodb
SQL