gaiety / ecto-migration-search-pg_trgm
0 mi piace
0 forks
1 files
Ultima volta attivo 6 months ago
| 1 | defmodule MyProject.Repo.Migrations.ItemsSearch do |
| 2 | use Ecto.Migration |
| 3 | |
| 4 | def up do |
| 5 | execute "CREATE EXTENSION IF NOT EXISTS pg_trgm;" |
| 6 | |
| 7 | execute """ |
| 8 | CREATE INDEX items_search_index |
| 9 | ON items |
| 10 | USING gin ((name) gin_trgm_ops); |
Più nuovi
Più vecchi