pg_trgm
A contrib module providing functions and operators for determining the similarity of alphanumeric text based on trigram matching, and index operator classes for fast string searching
pg_trgm
is a contrib module providing functions and operators for determining the similarity of alphanumeric text based on trigram matching, and index operator classes for fast string searching.
Change history
- PostgreSQL 13
- marked as a
trusted extension
(commit eb67623c)
- marked as a
- PostgreSQL 11 (extension version 1.4)
- support for strict word similarity added (commit be8a7a68)
- PostgreSQL 9.6 (extension version 1.3)
- function cleanup and parallel query support (commit 749a787c)
- PostgreSQL 9.6 (extension version 1.2)
- PostgreSQL 9.3 (extension version 1.1)
- support indexing of regular-expression searches (commit 3ccae48f)
- PostgreSQL 9.1 (extension version 1.0)
- PostgreSQL 8.0
- added (commit cbfa4092)
Note: any modifications before PostgreSQL 9.1 are not recorded here.
References
- PostgreSQL documentation: pg_trgm
Useful links
- Fuzzy string matching with Trigram and Trigraphs - article from Postgres OnLine Journal
Categories
See also
pg_bigm, PGroonga