postgresql - Rails 4 pgsql add_index with type GIN or GiST

Question

In Rails it is possible to do:

add_index :table, :column_name, :using => 'btree'

Is it possible in Rails 4 with PGSQL to add a GIN or GiST index like:

add_index :students, :name, :using => 'gin'

Or do I have use manual execute statements? The notion behind this is I would like to keep schema.rb instead of using structure.sql

question from:https://stackoverflow.com/questions/18725081/rails-4-pgsql-add-index-with-type-gin-or-gist

Answer 1

In Rails 4, you can now do something like this in a migration:

add_index :products, :data, using: :gin