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

2 votes259 views1 answer
Sql float to int
SQL
0 vote324 views3 answers
Delete in SQL SERVER
SQL
0 vote312 views1 answer
Sql change date format
SQL
0 vote441 views5 answers
Right join
SQL
0 vote340 views2 answers
Sql auto update dupdated_at
SQL
0 vote293 views1 answer
Mariadb LOAD DATA INFILE
SQL
0 vote321 views1 answer
Get rows from 1 table with other table empty mysql
SQL
10 votes326 views6 answers
Sql between
SQL
3 votes328 views2 answers
Sql server current date without time
SQL
1 vote366 views1 answer
Oracle select first row order by
SQL