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

23 votes239 views6 answers
Create table sql server
SQL
0 vote237 views1 answer
Hoq to import database source
SQL
0 vote222 views1 answer
SQL Server format datetime
SQL
2 votes273 views3 answers
How to replace null values in sql
SQL
5 votes223 views1 answer
Oracle scan source ddl
SQL
0 vote222 views1 answer
Postgresql select fast check no rows
SQL
0 vote227 views1 answer
Oracle sql procedure return value
SQL
0 vote220 views1 answer
Sql create table with datetime automatically
SQL
17 votes209 views2 answers
How to assign date field for table in mysql
SQL
4 votes223 views4 answers
What is primary key
SQL