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 vote314 views1 answer
Select only one row sql
SQL
50 votes409 views6 answers
Install mysql on ubuntu
SQL
11 votes336 views1 answer
Oracle view ddl
SQL
0 vote345 views1 answer
Oracle sql number to varchar2
SQL
37 votes518 views3 answers
Sql check duplicate value in column
SQL
3 votes354 views1 answer
Postgresql if null then 0
SQL
0 vote321 views1 answer
Oracle search columns in schema
SQL
0 vote340 views1 answer
Delete duplicate rows
SQL
7 votes342 views4 answers
Mysql delete older duplicates
SQL
4 votes329 views4 answers
Sqlite describe table
SQL