A contrib module providing functionality for determining the similarity of text based on trigram matching

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.

pg_trgm was added in PostgreSQL 8.0.

Change history

Note: some modifications prior to PostgreSQL 9.1 may not be recorded here.

  • PostgreSQL documentation: pg_trgm


Contrib module, Extension, Performance, Text search

See also

pg_bigm, PGroonga