This is the multi-page printable view of this section. Click here to print.

Return to the regular view of this page.

Category: FTS

FTS: ElasticSearch Alternative with BM25, 2-gram/3-gram Fuzzy Search, Zhparser & Hunspell Segregation Dicts, etc…

FTS category has 15 available extensions:

Extension (URL) Alias Repo Version Category License LOAD DDL TRUST RELOC Description
pg_search pg_search PIGSTY 0.11.1 FTS AGPLv3 pg_search: Full text search for PostgreSQL using BM25
pg_bigm pg_bigm PGDG 1.2 FTS PostgreSQL create 2-gram (bigram) index for faster full text search.
zhparser zhparser PIGSTY 2.2 FTS PostgreSQL a parser for full-text search of Chinese
hunspell_cs_cz hunspell_cs_cz PIGSTY 1.0 FTS PostgreSQL Czech Hunspell Dictionary
hunspell_de_de hunspell_de_de PIGSTY 1.0 FTS PostgreSQL German Hunspell Dictionary
hunspell_en_us hunspell_en_us PIGSTY 1.0 FTS PostgreSQL en_US Hunspell Dictionary
hunspell_fr hunspell_fr PIGSTY 1.0 FTS PostgreSQL French Hunspell Dictionary
hunspell_ne_np hunspell_ne_np PIGSTY 1.0 FTS PostgreSQL Nepali Hunspell Dictionary
hunspell_nl_nl hunspell_nl_nl PIGSTY 1.0 FTS PostgreSQL Dutch Hunspell Dictionary
hunspell_nn_no hunspell_nn_no PIGSTY 1.0 FTS PostgreSQL Norwegian (norsk) Hunspell Dictionary
hunspell_pt_pt hunspell_pt_pt PIGSTY 1.0 FTS PostgreSQL Portuguese Hunspell Dictionary
hunspell_ru_ru hunspell_ru_ru PIGSTY 1.0 FTS PostgreSQL Russian Hunspell Dictionary
hunspell_ru_ru_aot hunspell_ru_ru_aot PIGSTY 1.0 FTS PostgreSQL Russian Hunspell Dictionary (from AOT.ru group)
fuzzystrmatch fuzzystrmatch CONTRIB 1.2 FTS PostgreSQL determine similarities and distance between strings
pg_trgm pg_trgm CONTRIB 1.6 FTS PostgreSQL text similarity measurement and index searching based on trigrams

1 - pg_search

pg_search: Full text search for PostgreSQL using BM25

Overview

PIGSTY 3rd Party Extension: pg_search : pg_search: Full text search for PostgreSQL using BM25

Information

Metadata

  • Version: 0.11.1
  • PG Vers: 17,16,15,14
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Relocatable
  • Trusted: Trusted, Can be created by user with CREATE Privilege
  • Schemas: paradedb
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: pg_search_$v
  • RPM Ver : 0.11.1
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pg-search
  • DEB Ver : 0.11.1
  • DEB Deps: Nil

Details

2 - pg_bigm

create 2-gram (bigram) index for faster full text search.

Overview

PGDG 3rd Party Extension: pg_bigm : create 2-gram (bigram) index for faster full text search.

Information

Metadata

  • Version: 1.2
  • PG Vers: 17,16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PGDG
  • RPM Name: pg_bigm_$v*
  • RPM Ver : 1.2
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pg-bigm
  • DEB Ver : 1.2
  • DEB Deps: Nil

Details

3 - zhparser

a parser for full-text search of Chinese

Overview

PIGSTY 3rd Party Extension: zhparser : a parser for full-text search of Chinese

Information

Metadata

  • Version: 2.2
  • PG Vers: 17,16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: zhparser_$v*
  • RPM Ver : 2.2
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-zhparser
  • DEB Ver : 2.2
  • DEB Deps: Nil

Details

4 - hunspell_cs_cz

Czech Hunspell Dictionary

Overview

PIGSTY 3rd Party Extension: hunspell_cs_cz : Czech Hunspell Dictionary

Information

Metadata

  • Version: 1.0
  • PG Vers: 17,16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: hunspell_cs_cz_$v
  • RPM Ver : 1.0
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-hunspell-cs-cz
  • DEB Ver : 1.0
  • DEB Deps: Nil

Details

5 - hunspell_de_de

German Hunspell Dictionary

Overview

PIGSTY 3rd Party Extension: hunspell_de_de : German Hunspell Dictionary

Information

Metadata

  • Version: 1.0
  • PG Vers: 17,16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: hunspell_de_de_$v
  • RPM Ver : 1.0
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-hunspell-de-de
  • DEB Ver : 1.0
  • DEB Deps: Nil

Details

6 - hunspell_en_us

en_US Hunspell Dictionary

Overview

PIGSTY 3rd Party Extension: hunspell_en_us : en_US Hunspell Dictionary

Information

Metadata

  • Version: 1.0
  • PG Vers: 17,16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: hunspell_en_us_$v
  • RPM Ver : 1.0
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-hunspell-en-us
  • DEB Ver : 1.0
  • DEB Deps: Nil

Details

7 - hunspell_fr

French Hunspell Dictionary

Overview

PIGSTY 3rd Party Extension: hunspell_fr : French Hunspell Dictionary

Information

Metadata

  • Version: 1.0
  • PG Vers: 17,16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: hunspell_fr_$v
  • RPM Ver : 1.0
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-hunspell-fr
  • DEB Ver : 1.0
  • DEB Deps: Nil

Details

8 - hunspell_ne_np

Nepali Hunspell Dictionary

Overview

PIGSTY 3rd Party Extension: hunspell_ne_np : Nepali Hunspell Dictionary

Information

Metadata

  • Version: 1.0
  • PG Vers: 17,16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: hunspell_ne_np_$v
  • RPM Ver : 1.0
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-hunspell-ne-np
  • DEB Ver : 1.0
  • DEB Deps: Nil

Details

9 - hunspell_nl_nl

Dutch Hunspell Dictionary

Overview

PIGSTY 3rd Party Extension: hunspell_nl_nl : Dutch Hunspell Dictionary

Information

Metadata

  • Version: 1.0
  • PG Vers: 17,16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: hunspell_nl_nl_$v
  • RPM Ver : 1.0
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-hunspell-nl-nl
  • DEB Ver : 1.0
  • DEB Deps: Nil

Details

10 - hunspell_nn_no

Norwegian (norsk) Hunspell Dictionary

Overview

PIGSTY 3rd Party Extension: hunspell_nn_no : Norwegian (norsk) Hunspell Dictionary

Information

Metadata

  • Version: 1.0
  • PG Vers: 17,16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: hunspell_nn_no_$v
  • RPM Ver : 1.0
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-hunspell-nn-no
  • DEB Ver : 1.0
  • DEB Deps: Nil

Details

11 - hunspell_pt_pt

Portuguese Hunspell Dictionary

Overview

PIGSTY 3rd Party Extension: hunspell_pt_pt : Portuguese Hunspell Dictionary

Information

Metadata

  • Version: 1.0
  • PG Vers: 17,16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: hunspell_pt_pt_$v
  • RPM Ver : 1.0
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-hunspell-pt-pt
  • DEB Ver : 1.0
  • DEB Deps: Nil

Details

12 - hunspell_ru_ru

Russian Hunspell Dictionary

Overview

PIGSTY 3rd Party Extension: hunspell_ru_ru : Russian Hunspell Dictionary

Information

Metadata

  • Version: 1.0
  • PG Vers: 17,16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: hunspell_ru_ru_$v
  • RPM Ver : 1.0
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-hunspell-ru-ru
  • DEB Ver : 1.0
  • DEB Deps: Nil

Details

13 - hunspell_ru_ru_aot

Russian Hunspell Dictionary (from AOT.ru group)

Overview

PIGSTY 3rd Party Extension: hunspell_ru_ru_aot : Russian Hunspell Dictionary (from AOT.ru group)

Information

Metadata

  • Version: 1.0
  • PG Vers: 17,16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: hunspell_ru_ru_aot_$v
  • RPM Ver : 1.0
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-hunspell-ru-ru-aot
  • DEB Ver : 1.0
  • DEB Deps: Nil

Details

14 - fuzzystrmatch

determine similarities and distance between strings

Overview

CONTRIB Built-in Extension: fuzzystrmatch : determine similarities and distance between strings

Information

Metadata

  • Version: 1.2
  • PG Vers: 17,16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Trusted, Can be created by user with CREATE Privilege
  • Schemas: N/A
  • Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension

Details

15 - pg_trgm

text similarity measurement and index searching based on trigrams

Overview

CONTRIB Built-in Extension: pg_trgm : text similarity measurement and index searching based on trigrams

Information

Metadata

  • Version: 1.6
  • PG Vers: 17,16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension

Details