select open change scope Open full search

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

PostgreSQL Extension Catalogue

Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.

tsearch2 · Deprecated Amazon RDS PostgreSQL 10 compatibility extension for applications using pre-8.3 tsearch2 full-text-search APIs. · 1.0 · Full-text search · PostgreSQL · C · Not packagedpg_textsearch · Full-text search with BM25 ranking · 1.4.0 · Full-text search · PostgreSQL · C · Packagedzhparser · a parser for full-text search of Chinese · 2.3 · Full-text search · PostgreSQL · C · Packagedpgroonga · Use Groonga as index, fast full text search platform for all languages! · 4.0.4 · Full-text search · PostgreSQL · C · Packagedpgroonga_database · PGroonga database management module · 4.0.4 · Full-text search · PostgreSQL · C · Packagedacdat · Compiled Aho-Corasick double-array machines for exact multi-pattern matching and replacement in PostgreSQL. · 0.1.1 · Full-text search · Apache-2.0 · C · Packagedbiscuit · IAM-LIKE pattern matching with bitmap indexing · 3.1.0 · Full-text search · MIT · C · Packagedpg_biscuit · A fast bitmap-based index for PostgreSQL · 1.0 · Full-text search · MIT · C · Not packagedpg_bigm · create 2-gram (bigram) index for faster full text search. · 1.2 · Full-text search · PostgreSQL · C · Packagedpsql_bm25s · PostgreSQL extension for BM25-family lexical retrieval · 0.4.14 · Full-text search · Apache-2.0 · C · Packagedsphinx · C connector for querying and updating an external SphinxSearch server from PostgreSQL. · 0.3 · Full-text search · MIT · C · Not packagedpg_cjk_parser · CJK bigram parser derived from PostgreSQL full-text search · 0.1.0 · Full-text search · PostgreSQL · C · Packagedpg_scws · a parser for full-text search of Chinese · 1.0 · Full-text search · BSD-3-Clause · C · Not packagedthai_parser · Thai-language parser and text search configuration for PostgreSQL full-text search. · 1.0.0 · Full-text search · Unknown · C · Not packagedkor_search · A PostgreSQL extension for Korean-English text search. · 1.0.0 · Full-text search · MIT · C · Not packagedtsvector2 · Compressed alternative to PostgreSQL tsvector without the original 1 MB limit, with compatible search functions and GIN, GiST, and optional RUM indexing. · 1.0 · Full-text search · PostgreSQL · C · Not packagedsphinxlink · C extension for issuing SphinxSearch or ManticoreSearch queries from PostgreSQL through the MySQL-compatible protocol. · 1.4 · Full-text search · Unknown · C · Not packagedpg_tsparser · Parser for PostgreSQL text search · 1.0 · Full-text search · PostgreSQL · C · Not packagedtsexample · Example C extension that defines a custom full-text parser, dictionary template, dictionary, and text-search configuration. · 1.0 · Full-text search · Unknown · C · Not packageddict_voikko · Finnish full-text-search dictionary using Voikko morphological analysis. · 1.0 · Full-text search · PostgreSQL · C · Not packagedtsexact · Full-text-search helpers for exact phrase matching on PostgreSQL 9.5 and earlier. · 1.0 · Full-text search · PostgreSQL · C · Not packagedvgram · Variable-length grams · 1.0 · Full-text search · PostgreSQL · C · Not packagedshared_ispell · Shared-memory ispell dictionary template for reducing per-session initialization and memory. · 1.0.0 · Full-text search · BSD-2-Clause · C · Not packagedunidecode · ASCII transliterations of Unicode text · 0.0.6 · Full-text search · Unknown · C · Not packagedwildspeed · GIN operator class for fast wildcard LIKE searches using permuterm indexing · 1.0 · Full-text search · GPL-2.0 · C · Not packagedsnowball_bilingual · snowball_bilingual - add-on dictionary template using the combined results of two snowball stemmers · 1.0 · Full-text search · AGPL-3.0 · C · Not packagedtsearch_extras · Full-text-search helpers for returning match locations and extracting tsvector lexemes. · 1.0 · Full-text search · PostgreSQL · C · Not packagednorasearch · NoraSearch is a high-performance search engine for PostgreSQL. · 1.0 · Full-text search · MIT · C · Not packagedpg_hspell · Full text search dictionary template for Hebrew text using libhspell · 1.0 · Full-text search · MPL-2.0 · C · Not packageddict_exclude · Full-text search dictionary that filters stop words using regular-expression rules. · 1.0 · Full-text search · PostgreSQL · C · Not packageddict_id · Indonesian-language full-text search stemming dictionary based on cSastrawi · 1.0 · Full-text search · PostgreSQL · C · Not packagedmusicbrainz_unaccent · Removes accents from Unicode data · 1.0.0 · Full-text search · GPL-2.0 · C · Not packagedpg_tre · Native PostgreSQL index access method for approximate regular-expression matching · 3.0.2 · Full-text search · MIT · C · Not packagedpg_icu_parser · Full text search parser using ICU boundary analysis · 1.0 · Full-text search · MPL-2.0 · C · Not packagedsimple_parser · C full-text-search parser that splits input only at ASCII space characters, preserving punctuation such as underscores inside tokens. · 1.0 · Full-text search · PostgreSQL · C · Not packagedtest_parser · Example C extension implementing a custom PostgreSQL full-text-search parser. · 1.0 · Full-text search · Unknown · C · Not packagedall_substrings_tokenizer · Tokenizes text to all substrings bigger than a fixed character length. · 0.1 · Full-text search · Unknown · C · Not packageddict_regex · Full-text-search dictionary with regular-expression rules. · 1.0 · Full-text search · Unknown · C · Not packageddict_translate · Text search dictionary template that normalizes lexemes and expands them to configured translations. · 1.0 · Full-text search · Unknown · C · Not packagedsetrank · TF-IDF and cover-density ranking functions for tsvector/tsquery using document-frequency statistics from a table. · 1.0 · Full-text search · Unknown · C · Not packagedsimilarity · C extension that computes a normalized similarity score between two strings using an fstrcmp-style approximate matching algorithm. · 1.0 · Full-text search · GPL-2.0 · C · Not packagedsnowball_ext · Extensible Snowball text-search dictionary template with a Nepali stemmer. · 1.0 · Full-text search · PostgreSQL · C · Not packagedsoundex-type · soundex - type · 1.0.0 · Full-text search · PostgreSQL · C · Not packageddict_roman · Full-text search dictionary that converts Roman numeral tokens to Arabic integers. · 1.0 · Full-text search · Unknown · C · Not packagedfzy · FZY algorithm for PostgreSQL · 0.0.1 · Full-text search · MIT · C · Not packagedludia_funcs · Ludia full-text search helper functions · 1.0 · Full-text search · LGPL-2.1 · C · Not packagedmipt-asj · Abbreviation-aware approximate string joins using the Tao-Deng-Stonebraker algorithm · 0.1 · Full-text search · MIT · C · Not packagedpg_ac · PostgreSQL extension for full text search · 0.1 · Full-text search · Unknown · C · Not packagedpg_textparser · Text search parser · 1.0 · Full-text search · MIT · C · Not packagedsoundex-function · soundex - function for comparing strings · 1.0.0 · Full-text search · PostgreSQL · C · Not packagedtwitter_parser · Minimal C full-text-search parser that tokenizes Twitter-style hashtags and mentions. · 1.0 · Full-text search · Unknown · C · Not packageddict_maxlen · text search template for a dictionary filtering out long words · 1.0 · Full-text search · Unknown · C · Not packagedfuzzering · search string content · 0.0.1 · Full-text search · Unknown · C · Not packagedfuzzysearch · PostgreSQL extension for strings fuzzy matching · 1.0 · Full-text search · Unknown · C · Not packagedfuzzystrmatch · determine similarities and distance between strings · 1.2 · Full-text search · PostgreSQL · C · Packagedjusquci · French tokenizer and PostgreSQL full-text-search parser. · 1.0 · Full-text search · GPL-3.0 · C · Not packagedpg_fts · Full-text search with BM25 and BM25F ranking · 1.8.3 · Full-text search · PostgreSQL · C · Packagedpg_probablepeople · CRF-based parsing of personal and organization names into structured components. · 0.0.1 · Full-text search · MIT · C · Not packagedpg_trgm · text similarity measurement and index searching based on trigrams · 1.6 · Full-text search · PostgreSQL · C · Packagedpg_weave · BM25 lexical search through the weave index access method · 0.10.0 · Full-text search · PostgreSQL · C · Not packagedtag_parser · PostgreSQL Text Search parser extension for character separated lexemes · 0.1.0 · Full-text search · MIT · C · Not packagedvmatch · Text similarity functions and a fuzzy-match /= operator with typo-aware weighting. · 1.0 · Full-text search · Unknown · C · Not packaged

62 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
twitter_parser 1.0 Minimal C full-text-search parser that tokenizes Twitter-style hashtags and mentions. FTS C 1
dict_maxlen 1.0 text search template for a dictionary filtering out long words FTS C
fuzzering 0.0.1 search string content FTS C
fuzzysearch 1.0 PostgreSQL extension for strings fuzzy matching FTS C
fuzzystrmatch 1.2 determine similarities and distance between strings FTS PostgreSQL C 14–18
jusquci 1.0 French tokenizer and PostgreSQL full-text-search parser. FTS GPL-3.0 C 16
pg_fts 1.8.3 Full-text search with BM25 and BM25F ranking FTS PostgreSQL C 17–18
pg_probablepeople 0.0.1 CRF-based parsing of personal and organization names into structured components. FTS MIT C
pg_trgm 1.6 text similarity measurement and index searching based on trigrams FTS PostgreSQL C 14–18
pg_weave 0.10.0 BM25 lexical search through the weave index access method FTS PostgreSQL C 17–18
tag_parser 0.1.0 PostgreSQL Text Search parser extension for character separated lexemes FTS MIT C
vmatch 1.0 Text similarity functions and a fuzzy-match /= operator with typo-aware weighting. FTS C