select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Full-text search

pg_tre

Native PostgreSQL index access method for approximate regular-expression matching

pgext.cloud · Source code · Website · Documentation · License text · Control file

Overview

Packagepg_tre
Version3.0.2
PostgreSQL versions17 · 18
RepositoryUnspecified
Extension typePreloaded
Project statusActive
Requires CREATE EXTENSIONYes
Requires preloadYes
TrustedNo
RelocatableNo
Shared librariespg_tre
Stars4
Latest commit2026-07-25
Latest release2026-07-25
Catalogue updated2026-08-07

Related extensions

See also

pg_trgmtext similarity measurement and index searching based on trigrams
pg_textsearchFull-text search with BM25 ranking
pg_ftsFull-text search with BM25 and BM25F ranking
vectorvector data type and ivfflat and hnsw access methods
pg_inferExpose transformer model knowledge as SQL relations and a custom index access method
pg_mentatDatomic-compatible data model and Datalog query engine inside PostgreSQL