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 vote357 views1 answer
Postgresql default value boolean
SQL
0 vote369 views1 answer
Select insert new table sql server
SQL
5 votes346 views1 answer
Oracle asynchronous query
SQL
1 vote365 views1 answer
Postgresql round double precision
SQL
11 votes350 views2 answers
Safe mode off mysql
SQL
1 vote373 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
0 vote376 views1 answer
Group by max date
SQL
10 votes353 views2 answers
Forgot my mysql password mac
SQL
7 votes334 views4 answers
How to reset the identity column in sql server
SQL
1 vote377 views1 answer
Date in where on datetime column clause mysql
SQL