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 vote416 views1 answer
What logs are available on RDS MySQL?
SQL
8 votes308 views1 answer
Similarities between ddl and dml
SQL
0 vote333 views1 answer
How to change mysql port in xampp
SQL
0 vote337 views1 answer
Nueva tabla mysql
SQL
0 vote355 views1 answer
Find and replace database table phpmyadmin
SQL
0 vote337 views1 answer
Flask sqlalchemy decimal
SQL
0 vote341 views1 answer
How to get table current identity value in sql server
SQL
0 vote316 views0 answer
SQL
0 vote382 views1 answer
Add created and updatedAt fields in mysql
SQL
0 vote352 views1 answer
How to use lower case in mysql
SQL