pg_trgm

text similarity measurement and index searching based on trigrams

Overview

ID	Extension	Package	Version	Category	License	Language
2190	pg_trgm	pg_trgm	`1.6`	FTS	PostgreSQL	C

Attribute	Has Binary	Has Library	Need Load	Has DDL	Relocatable	Trusted
--s-d--	No	Yes	No	Yes	no	no

Relationships
See Also	pg_similarity pg_bigm fuzzystrmatch unaccent smlar pgroonga_database rum citext

PG18	PG17	PG16	PG15	PG14	PG13
1.6	1.6	1.6	1.6	1.6	1.6

This is a built-in contrib extension ship with the PostgreSQL kernel

Create this extension with:

CREATE EXTENSION pg_trgm;

Last updated on 2025-10-28