CODE EXAMPLE FOR SQL

list all indexes postgres

select * from pg_indexes
where schemaname like '<schema-name>' and tablename like '<table-name>'