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 vote159 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
1 vote199 views1 answer
Print year of a date sql
SQL
0 vote189 views1 answer
What does the -p flag do in mysql cli
SQL
6 votes165 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
4 votes153 views2 answers
Dbms_scheduler stop job
SQL
1 vote219 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
6 votes254 views2 answers
Database url postgres
SQL
0 vote176 views1 answer
Datagrip exec
SQL
3 votes152 views4 answers
Order by desc postgres
SQL
5 votes192 views1 answer
Ora-00054 resource busy and acquire with nowait
SQL