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 vote187 views1 answer
Query for backup a database at another location in file system
SQL
2 votes147 views1 answer
Match in sql server
SQL
0 vote178 views1 answer
Rename view mysql
SQL
0 vote180 views2 answers
Disadvantages of stored procedures sql
SQL
2 votes182 views1 answer
Pdo mysql insert
SQL
7 votes177 views3 answers
Python and mysql connectivity
SQL
0 vote179 views1 answer
Sql server alter table column nullable
SQL
0 vote193 views1 answer
Mysql join column order By and group By
SQL
3 votes179 views1 answer
V$session not found in oracle
SQL
0 vote186 views1 answer
Max length found in mysql
SQL