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

1 vote235 views1 answer
Drop column if exists sql server
SQL
0 vote199 views1 answer
Intellij mysql set timezone
SQL
2 votes196 views1 answer
Drop sequence
SQL
0 vote224 views1 answer
Kimball data warehouse sql calendar
SQL
12 votes174 views3 answers
Duplicate a column in sql
SQL
0 vote130 views1 answer
How to see the content of tables in pgadmin
SQL
0 vote192 views1 answer
Sql #region
SQL
1 vote180 views1 answer
Simple project for database
SQL
0 vote190 views1 answer
Is there any limit of using joins in single mysql query ?
SQL
5 votes197 views1 answer
Oracle list days between two dates
SQL