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
tsearch2 1.0 Deprecated Amazon RDS PostgreSQL 10 compatibility extension for applications using pre-8.3 tsearch2 full-text-search APIs. FTS PostgreSQL C 10 22k
pg_textsearch 1.4.0 Full-text search with BM25 ranking FTS PostgreSQL C 17–18 4.0k
zhparser 2.3 a parser for full-text search of Chinese FTS PostgreSQL C 14–18 870
pgroonga 4.0.4 Use Groonga as index, fast full text search platform for all languages! FTS PostgreSQL C 14–18 748
pgroonga_database 4.0.4 PGroonga database management module FTS PostgreSQL C 14–18 748
acdat 0.1.1 Compiled Aho-Corasick double-array machines for exact multi-pattern matching and replacement in PostgreSQL. FTS Apache-2.0 C 14–18 664
biscuit 3.1.0 IAM-LIKE pattern matching with bitmap indexing FTS MIT C 16–18 300
pg_biscuit 1.0 A fast bitmap-based index for PostgreSQL FTS MIT C 300
pg_bigm 1.2 create 2-gram (bigram) index for faster full text search. FTS PostgreSQL C 14–18 152
psql_bm25s 0.4.14 PostgreSQL extension for BM25-family lexical retrieval FTS Apache-2.0 C 17–18 146
sphinx 0.3 C connector for querying and updating an external SphinxSearch server from PostgreSQL. FTS MIT C 51
pg_cjk_parser 0.1.0 CJK bigram parser derived from PostgreSQL full-text search FTS PostgreSQL C 14–18 41
pg_scws 1.0 a parser for full-text search of Chinese FTS BSD-3-Clause C 41
thai_parser 1.0.0 Thai-language parser and text search configuration for PostgreSQL full-text search. FTS C 10–18 41
kor_search 1.0.0 A PostgreSQL extension for Korean-English text search. FTS MIT C 16 37
tsvector2 1.0 Compressed alternative to PostgreSQL tsvector without the original 1 MB limit, with compatible search functions and GIN, GiST, and optional RUM indexing. FTS PostgreSQL C 10–13 27
sphinxlink 1.4 C extension for issuing SphinxSearch or ManticoreSearch queries from PostgreSQL through the MySQL-compatible protocol. FTS C 18
pg_tsparser 1.0 Parser for PostgreSQL text search FTS PostgreSQL C 17
tsexample 1.0 Example C extension that defines a custom full-text parser, dictionary template, dictionary, and text-search configuration. FTS C 15
dict_voikko 1.0 Finnish full-text-search dictionary using Voikko morphological analysis. FTS PostgreSQL C 12
tsexact 1.0 Full-text-search helpers for exact phrase matching on PostgreSQL 9.5 and earlier. FTS PostgreSQL C 10–18 12
vgram 1.0 Variable-length grams FTS PostgreSQL C 13–18 12
shared_ispell 1.0.0 Shared-memory ispell dictionary template for reducing per-session initialization and memory. FTS BSD-2-Clause C 10–18 10
unidecode 0.0.6 ASCII transliterations of Unicode text FTS C 10–18 7
wildspeed 1.0 GIN operator class for fast wildcard LIKE searches using permuterm indexing FTS GPL-2.0 C 7
snowball_bilingual 1.0 snowball_bilingual - add-on dictionary template using the combined results of two snowball stemmers FTS AGPL-3.0 C 6
tsearch_extras 1.0 Full-text-search helpers for returning match locations and extracting tsvector lexemes. FTS PostgreSQL C 10–11 6
norasearch 1.0 NoraSearch is a high-performance search engine for PostgreSQL. FTS MIT C 16–18 5
pg_hspell 1.0 Full text search dictionary template for Hebrew text using libhspell FTS MPL-2.0 C 10–18 5
dict_exclude 1.0 Full-text search dictionary that filters stop words using regular-expression rules. FTS PostgreSQL C 4
dict_id 1.0 Indonesian-language full-text search stemming dictionary based on cSastrawi FTS PostgreSQL C 4
musicbrainz_unaccent 1.0.0 Removes accents from Unicode data FTS GPL-2.0 C 4
pg_tre 3.0.2 Native PostgreSQL index access method for approximate regular-expression matching FTS MIT C 17–18 4
pg_icu_parser 1.0 Full text search parser using ICU boundary analysis FTS MPL-2.0 C 10–16 3
simple_parser 1.0 C full-text-search parser that splits input only at ASCII space characters, preserving punctuation such as underscores inside tokens. FTS PostgreSQL C 3
test_parser 1.0 Example C extension implementing a custom PostgreSQL full-text-search parser. FTS C 3
all_substrings_tokenizer 0.1 Tokenizes text to all substrings bigger than a fixed character length. FTS C 2
dict_regex 1.0 Full-text-search dictionary with regular-expression rules. FTS C 2
dict_translate 1.0 Text search dictionary template that normalizes lexemes and expands them to configured translations. FTS C 2
setrank 1.0 TF-IDF and cover-density ranking functions for tsvector/tsquery using document-frequency statistics from a table. FTS C 2
similarity 1.0 C extension that computes a normalized similarity score between two strings using an fstrcmp-style approximate matching algorithm. FTS GPL-2.0 C 2
snowball_ext 1.0 Extensible Snowball text-search dictionary template with a Nepali stemmer. FTS PostgreSQL C 2
soundex-type 1.0.0 soundex - type FTS PostgreSQL C 2
dict_roman 1.0 Full-text search dictionary that converts Roman numeral tokens to Arabic integers. FTS C 1
fzy 0.0.1 FZY algorithm for PostgreSQL FTS MIT C 11–13 1
ludia_funcs 1.0 Ludia full-text search helper functions FTS LGPL-2.1 C 10–18 1
mipt-asj 0.1 Abbreviation-aware approximate string joins using the Tao-Deng-Stonebraker algorithm FTS MIT C 1
pg_ac 0.1 PostgreSQL extension for full text search FTS C 1
pg_textparser 1.0 Text search parser FTS MIT C 1
soundex-function 1.0.0 soundex - function for comparing strings FTS PostgreSQL C 1