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

25 votes280 views3 answers
How to use a database to see tables mysql
SQL
1 vote289 views1 answer
Oracle get current schema
SQL
0 vote303 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
16 votes269 views2 answers
Add column if not exists mysql
SQL
2 votes289 views1 answer
Alter table add column and foreign key mysql
SQL
4 votes266 views1 answer
SQL find text in SP
SQL
1 vote278 views5 answers
What is in operator in sql
SQL
-1 vote302 views1 answer
How to Activate the database
SQL
5 votes285 views4 answers
Upload database mysql command line
SQL
16 votes269 views4 answers
Find duplicates mysql
SQL