text similarity measurement and index searching based on trigrams
pgext.cloud · Website · Documentation · License text · Control file
| Package | pg_trgm |
|---|---|
| Version | 1.6 |
| PostgreSQL versions | 14 · 15 · 16 · 17 · 18 |
| Repository | PostgreSQL contrib |
| Extension type | Standard |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | Yes |
| Latest commit | 2026-05-14 |
| Latest release | 2026-05-14 |
| Catalogue updated | 2026-07-29 |
| geohistorical_objects | Geohistorical objects support |
| hartonomous | Hartonomous substrate — schemas, types, tables, BLAKE3, S^3 geometry, traversal, UCD/UCA atoms |
| kor_search | A PostgreSQL extension for Korean-English text search. |
| maludb_core | A memory DBMS for long-term institutional memory, human-AI knowledge sharing, and contextual recall. PostgreSQL 17 extension. |
| pg_git | Implements Git-like repositories, commits, branches, merges and remote operations using PostgreSQL-native data and functions. |
| pg_sag_rag | Pure-SQL multi-hop event/entity retrieval, query routing, and in-database RAG evaluation. |
| postgres_ci | Implements the database backend for the defunct Postgres-CI service, including users, projects, builds, hooks, sessions, and notifications. |
| pg_similarity | support similarity queries |
| fuzzystrmatch | determine similarities and distance between strings |
| smlar | Effective similarity search |
| pg_bigm | create 2-gram (bigram) index for faster full text search. |
| pgpcre | Perl Compatible Regular Expression functions |
| re2 | ClickHouse-compatible regex functions using RE2 |
| biscuit | IAM-LIKE pattern matching with bitmap indexing |
| citext | data type for case-insensitive character strings |
| unaccent | text search dictionary that removes accents |
| pgroonga | Use Groonga as index, fast full text search platform for all languages! |