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 vote285 views1 answer
Postgres statistics
SQL
1 vote290 views2 answers
Pad zero sql server
SQL
0 vote293 views1 answer
Renommer base sql
SQL
3 votes267 views2 answers
Sqlite show table definition
SQL
0 vote294 views1 answer
Materialized view redshift
SQL
4 votes266 views1 answer
Sql data types
SQL
2 votes277 views1 answer
Sql ends with string
SQL
0 vote263 views2 answers
Which MySQL statement is used to delete data from a database
SQL
1 vote243 views2 answers
Delete auto increment mysql
SQL
9 votes274 views2 answers
Mysql change value
SQL