summaryrefslogtreecommitdiffstats
path: root/packages/sql/search_indexes.postgresql_psycopg2.sql
blob: a7eaf99896941305e7141a88e5168b8e82d48bca (plain)
1
2
3
CREATE EXTENSION IF NOT EXISTS pg_trgm;
CREATE INDEX packages_pkgname_trgm_gist ON packages USING gist (UPPER(pkgname) gist_trgm_ops);
CREATE INDEX packages_pkgdesc_trgm_gist ON packages USING gist (UPPER(pkgdesc) gist_trgm_ops);