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 vote348 views1 answer
Second last highest id in sql
SQL
11 votes297 views1 answer
Reset identity sql server
SQL
0 vote361 views1 answer
Change date format in oracle query
SQL
23 votes304 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
2 votes339 views1 answer
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = whatsapp and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote305 views1 answer
Get duplicate entry sql
SQL
2 votes333 views1 answer
Mariadb json select
SQL
0 vote322 views4 answers
Database stuck at restoring state
SQL
1 vote330 views1 answer
Sql where last 12 months
SQL
10 votes349 views2 answers
Mysql drop database if exists
SQL