Module: PhatPgsearch::PostgreSQL::SchemaStatements

Defined in:
lib/phat_pgsearch/postgresql.rb

Instance Method Summary collapse

Instance Method Details

#add_gin_index(table_name, column_name, options = {}) ⇒ Object 



19
20
21
22
23
 
# File 'lib/phat_pgsearch/postgresql.rb', line 19

def add_gin_index(table_name, column_name, options = {})
  index_name = index_name(table_name, :column => column_name)
  index_name = options[:name].to_s if options.key?(:name)
  execute "CREATE INDEX #{quote_column_name(index_name)} ON #{quote_table_name(table_name)} USING gin(#{quote_column_name(column_name)})"
end

#add_gist_index(table_name, column_name, options = {}) ⇒ Object 



25
26
27
28
29
 
# File 'lib/phat_pgsearch/postgresql.rb', line 25

def add_gist_index(table_name, column_name, options = {})
  index_name = index_name(table_name, :column => column_name)
  index_name = options[:name].to_s if options.key?(:name)
  execute "CREATE INDEX #{quote_column_name(index_name)} ON #{quote_table_name(table_name)} USING gist(#{quote_column_name(column_name)})"
end