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 vote211 views1 answer
Postgres get running query
SQL
2 votes223 views1 answer
Oracle sql query to make column data uppercase
SQL
0 vote240 views1 answer
Sql query to get column names and data types in sql server
SQL
0 vote232 views1 answer
Mysql select where field is a value
SQL
0 vote251 views1 answer
Mysql search like but first exact match
SQL
0 vote216 views1 answer
What are the aggregate function in sql
SQL
0 vote231 views1 answer
Change schema of all tables postgres
SQL
0 vote245 views1 answer
Querry mysql by 2 columns
SQL
0 vote249 views1 answer
SAP Return
SQL
0 vote244 views1 answer
Copy data from one postgres container to another
SQL