How to check if there is an index on a column through Rails console?

Question

Let's say I do Image.column_names and that shows all the columns such as post_id but how do I check if post_id has an index on it?

Answer 1

There is an index_exists? method on one of the ActiveRecord "connection adapters" classes.

You can use it like this:

ActiveRecord::Migration.connection.index_exists? :images, :post_id