Extensions
pg_similarity

pg_similarity

pg_similarity : support similarity queries

Overview

ID Extension Package Version Category License Language
1840
pg_similarity
pg_similarity
 1.0
RAG
BSD 3-Clause
C
Attribute Has Binary Has Library Need Load Has DDL Relocatable Trusted
--s-d-r
No
Yes
No
Yes
yes
no
Relationships
See Also
vector
smlar
fuzzystrmatch
pg_trgm
vchord
pg_bigm
citext
unaccent

Packages

Type Repo Version PG Major Compatibility Package Pattern Dependencies
EXT
MIXED
 1.0
18
17
16
15
14
13
 pg_similarity -
RPM
PIGSTY
 1.0
18
17
16
15
14
13
 pg_similarity_$v* -
DEB
PGDG
 1.0
18
17
16
15
14
13
 postgresql-$v-similarity -
Linux / PG PG18 PG17 PG16 PG15 PG14 PG13
el8.x86_64
PGDG 1.0
PIGSTY 1.0
PIGSTY 1.0
PIGSTY 1.0
PIGSTY 1.0
PIGSTY 1.0
el8.aarch64
PGDG 1.0
PIGSTY 1.0
PIGSTY 1.0
PIGSTY 1.0
PIGSTY 1.0
PIGSTY 1.0
el9.x86_64
PGDG 1.0
PIGSTY 1.0
PIGSTY 1.0
PIGSTY 1.0
PIGSTY 1.0
PIGSTY 1.0
el9.aarch64
PGDG 1.0
PIGSTY 1.0
PIGSTY 1.0
PIGSTY 1.0
PIGSTY 1.0
PIGSTY 1.0
el10.x86_64
PGDG 1.0
PGDG 1.0
PGDG 1.0
PGDG 1.0
PGDG 1.0
PGDG 1.0
el10.aarch64
PGDG 1.0
PGDG 1.0
PGDG 1.0
PGDG 1.0
PGDG 1.0
PGDG 1.0
d12.x86_64
PGDG 1.0
PGDG 1.0
PGDG 1.0
PGDG 1.0
PGDG 1.0
PGDG 1.0
d12.aarch64
PGDG 1.0
PGDG 1.0
PGDG 1.0
PGDG 1.0
PGDG 1.0
PGDG 1.0
d13.x86_64
PGDG 1.0
PGDG 1.0
PGDG 1.0
PGDG 1.0
PGDG 1.0
PGDG 1.0
d13.aarch64
PGDG 1.0
PGDG 1.0
PGDG 1.0
PGDG 1.0
PGDG 1.0
PGDG 1.0
u22.x86_64
PGDG 1.0
PGDG 1.0
PGDG 1.0
PGDG 1.0
PGDG 1.0
PGDG 1.0
u22.aarch64
PGDG 1.0
PGDG 1.0
PGDG 1.0
PGDG 1.0
PGDG 1.0
PGDG 1.0
u24.x86_64
PGDG 1.0
PGDG 1.0
PGDG 1.0
PGDG 1.0
PGDG 1.0
PGDG 1.0
u24.aarch64
PGDG 1.0
PGDG 1.0
PGDG 1.0
PGDG 1.0
PGDG 1.0
PGDG 1.0
Package Version OS ORG SIZE File URL
pg_similarity_18 1.0 el8.x86_64 pigsty 44.9 KiB pg_similarity_18-1.0-2PIGSTY.el8.x86_64.rpm
pg_similarity_18 1.0 el8.x86_64 pgdg 43.2 KiB pg_similarity_18-1.0-3PGDG.rhel8.x86_64.rpm
pg_similarity_18 1.0 el8.aarch64 pigsty 43.0 KiB pg_similarity_18-1.0-2PIGSTY.el8.aarch64.rpm
pg_similarity_18 1.0 el8.aarch64 pgdg 40.7 KiB pg_similarity_18-1.0-3PGDG.rhel8.aarch64.rpm
pg_similarity_18 1.0 el9.x86_64 pigsty 41.9 KiB pg_similarity_18-1.0-2PIGSTY.el9.x86_64.rpm
pg_similarity_18 1.0 el9.x86_64 pgdg 42.6 KiB pg_similarity_18-1.0-3PGDG.rhel9.x86_64.rpm
pg_similarity_18 1.0 el9.aarch64 pigsty 40.6 KiB pg_similarity_18-1.0-2PIGSTY.el9.aarch64.rpm
pg_similarity_18 1.0 el9.aarch64 pgdg 41.2 KiB pg_similarity_18-1.0-3PGDG.rhel9.aarch64.rpm
pg_similarity_18 1.0 el10.x86_64 pigsty 42.3 KiB pg_similarity_18-1.0-2PIGSTY.el10.x86_64.rpm
pg_similarity_18 1.0 el10.x86_64 pgdg 43.6 KiB pg_similarity_18-1.0-3PGDG.rhel10.x86_64.rpm
pg_similarity_18 1.0 el10.aarch64 pigsty 41.0 KiB pg_similarity_18-1.0-2PIGSTY.el10.aarch64.rpm
pg_similarity_18 1.0 el10.aarch64 pgdg 42.3 KiB pg_similarity_18-1.0-3PGDG.rhel10.aarch64.rpm
postgresql-18-similarity 1.0 d12.x86_64 pgdg 98.6 KiB postgresql-18-similarity_1.0-9.pgdg12+1_amd64.deb
postgresql-18-similarity 1.0 d12.aarch64 pgdg 96.2 KiB postgresql-18-similarity_1.0-9.pgdg12+1_arm64.deb
postgresql-18-similarity 1.0 d13.x86_64 pgdg 98.5 KiB postgresql-18-similarity_1.0-9.pgdg13+1_amd64.deb
postgresql-18-similarity 1.0 d13.aarch64 pgdg 96.2 KiB postgresql-18-similarity_1.0-9.pgdg13+1_arm64.deb
postgresql-18-similarity 1.0 u22.x86_64 pgdg 98.4 KiB postgresql-18-similarity_1.0-9.pgdg22.04+1_amd64.deb
postgresql-18-similarity 1.0 u22.aarch64 pgdg 96.2 KiB postgresql-18-similarity_1.0-9.pgdg22.04+1_arm64.deb
postgresql-18-similarity 1.0 u24.x86_64 pgdg 97.5 KiB postgresql-18-similarity_1.0-9.pgdg24.04+1_amd64.deb
postgresql-18-similarity 1.0 u24.aarch64 pgdg 94.9 KiB postgresql-18-similarity_1.0-9.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pg_similarity_17 1.0 el8.x86_64 pigsty 44.8 KiB pg_similarity_17-1.0-2PIGSTY.el8.x86_64.rpm
pg_similarity_17 1.0 el8.aarch64 pigsty 42.9 KiB pg_similarity_17-1.0-2PIGSTY.el8.aarch64.rpm
pg_similarity_17 1.0 el9.x86_64 pigsty 42.0 KiB pg_similarity_17-1.0-2PIGSTY.el9.x86_64.rpm
pg_similarity_17 1.0 el9.aarch64 pigsty 40.6 KiB pg_similarity_17-1.0-2PIGSTY.el9.aarch64.rpm
pg_similarity_17 1.0 el10.x86_64 pigsty 42.3 KiB pg_similarity_17-1.0-2PIGSTY.el10.x86_64.rpm
pg_similarity_17 1.0 el10.x86_64 pgdg 43.6 KiB pg_similarity_17-1.0-3PGDG.rhel10.x86_64.rpm
pg_similarity_17 1.0 el10.aarch64 pigsty 41.0 KiB pg_similarity_17-1.0-2PIGSTY.el10.aarch64.rpm
pg_similarity_17 1.0 el10.aarch64 pgdg 42.3 KiB pg_similarity_17-1.0-3PGDG.rhel10.aarch64.rpm
postgresql-17-similarity 1.0 d12.x86_64 pgdg 98.7 KiB postgresql-17-similarity_1.0-9.pgdg12+1_amd64.deb
postgresql-17-similarity 1.0 d12.aarch64 pgdg 96.1 KiB postgresql-17-similarity_1.0-9.pgdg12+1_arm64.deb
postgresql-17-similarity 1.0 d13.x86_64 pgdg 98.8 KiB postgresql-17-similarity_1.0-9.pgdg13+1_amd64.deb
postgresql-17-similarity 1.0 d13.aarch64 pgdg 96.0 KiB postgresql-17-similarity_1.0-9.pgdg13+1_arm64.deb
postgresql-17-similarity 1.0 u22.x86_64 pgdg 103.7 KiB postgresql-17-similarity_1.0-9.pgdg22.04+1_amd64.deb
postgresql-17-similarity 1.0 u22.aarch64 pgdg 101.5 KiB postgresql-17-similarity_1.0-9.pgdg22.04+1_arm64.deb
postgresql-17-similarity 1.0 u24.x86_64 pgdg 97.6 KiB postgresql-17-similarity_1.0-9.pgdg24.04+1_amd64.deb
postgresql-17-similarity 1.0 u24.aarch64 pgdg 95.0 KiB postgresql-17-similarity_1.0-9.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pg_similarity_16 1.0 el8.x86_64 pigsty 44.8 KiB pg_similarity_16-1.0-2PIGSTY.el8.x86_64.rpm
pg_similarity_16 1.0 el8.aarch64 pigsty 43.0 KiB pg_similarity_16-1.0-2PIGSTY.el8.aarch64.rpm
pg_similarity_16 1.0 el9.x86_64 pigsty 41.9 KiB pg_similarity_16-1.0-2PIGSTY.el9.x86_64.rpm
pg_similarity_16 1.0 el9.aarch64 pigsty 40.5 KiB pg_similarity_16-1.0-2PIGSTY.el9.aarch64.rpm
pg_similarity_16 1.0 el10.x86_64 pigsty 42.3 KiB pg_similarity_16-1.0-2PIGSTY.el10.x86_64.rpm
pg_similarity_16 1.0 el10.x86_64 pgdg 43.6 KiB pg_similarity_16-1.0-3PGDG.rhel10.x86_64.rpm
pg_similarity_16 1.0 el10.aarch64 pigsty 41.0 KiB pg_similarity_16-1.0-2PIGSTY.el10.aarch64.rpm
pg_similarity_16 1.0 el10.aarch64 pgdg 42.3 KiB pg_similarity_16-1.0-3PGDG.rhel10.aarch64.rpm
postgresql-16-similarity 1.0 d12.x86_64 pgdg 98.7 KiB postgresql-16-similarity_1.0-9.pgdg12+1_amd64.deb
postgresql-16-similarity 1.0 d12.aarch64 pgdg 96.1 KiB postgresql-16-similarity_1.0-9.pgdg12+1_arm64.deb
postgresql-16-similarity 1.0 d13.x86_64 pgdg 98.6 KiB postgresql-16-similarity_1.0-9.pgdg13+1_amd64.deb
postgresql-16-similarity 1.0 d13.aarch64 pgdg 96.2 KiB postgresql-16-similarity_1.0-9.pgdg13+1_arm64.deb
postgresql-16-similarity 1.0 u22.x86_64 pgdg 103.6 KiB postgresql-16-similarity_1.0-9.pgdg22.04+1_amd64.deb
postgresql-16-similarity 1.0 u22.aarch64 pgdg 101.5 KiB postgresql-16-similarity_1.0-9.pgdg22.04+1_arm64.deb
postgresql-16-similarity 1.0 u24.x86_64 pgdg 97.5 KiB postgresql-16-similarity_1.0-9.pgdg24.04+1_amd64.deb
postgresql-16-similarity 1.0 u24.aarch64 pgdg 95.1 KiB postgresql-16-similarity_1.0-9.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pg_similarity_15 1.0 el8.x86_64 pigsty 45.9 KiB pg_similarity_15-1.0-2PIGSTY.el8.x86_64.rpm
pg_similarity_15 1.0 el8.aarch64 pigsty 43.9 KiB pg_similarity_15-1.0-2PIGSTY.el8.aarch64.rpm
pg_similarity_15 1.0 el9.x86_64 pigsty 44.1 KiB pg_similarity_15-1.0-2PIGSTY.el9.x86_64.rpm
pg_similarity_15 1.0 el9.aarch64 pigsty 42.5 KiB pg_similarity_15-1.0-2PIGSTY.el9.aarch64.rpm
pg_similarity_15 1.0 el10.x86_64 pigsty 44.5 KiB pg_similarity_15-1.0-2PIGSTY.el10.x86_64.rpm
pg_similarity_15 1.0 el10.x86_64 pgdg 45.8 KiB pg_similarity_15-1.0-3PGDG.rhel10.x86_64.rpm
pg_similarity_15 1.0 el10.aarch64 pigsty 43.0 KiB pg_similarity_15-1.0-2PIGSTY.el10.aarch64.rpm
pg_similarity_15 1.0 el10.aarch64 pgdg 44.2 KiB pg_similarity_15-1.0-3PGDG.rhel10.aarch64.rpm
postgresql-15-similarity 1.0 d12.x86_64 pgdg 99.5 KiB postgresql-15-similarity_1.0-9.pgdg12+1_amd64.deb
postgresql-15-similarity 1.0 d12.aarch64 pgdg 96.9 KiB postgresql-15-similarity_1.0-9.pgdg12+1_arm64.deb
postgresql-15-similarity 1.0 d13.x86_64 pgdg 99.7 KiB postgresql-15-similarity_1.0-9.pgdg13+1_amd64.deb
postgresql-15-similarity 1.0 d13.aarch64 pgdg 96.9 KiB postgresql-15-similarity_1.0-9.pgdg13+1_arm64.deb
postgresql-15-similarity 1.0 u22.x86_64 pgdg 105.4 KiB postgresql-15-similarity_1.0-9.pgdg22.04+1_amd64.deb
postgresql-15-similarity 1.0 u22.aarch64 pgdg 103.0 KiB postgresql-15-similarity_1.0-9.pgdg22.04+1_arm64.deb
postgresql-15-similarity 1.0 u24.x86_64 pgdg 99.3 KiB postgresql-15-similarity_1.0-9.pgdg24.04+1_amd64.deb
postgresql-15-similarity 1.0 u24.aarch64 pgdg 96.4 KiB postgresql-15-similarity_1.0-9.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pg_similarity_14 1.0 el8.x86_64 pigsty 45.9 KiB pg_similarity_14-1.0-2PIGSTY.el8.x86_64.rpm
pg_similarity_14 1.0 el8.aarch64 pigsty 43.9 KiB pg_similarity_14-1.0-2PIGSTY.el8.aarch64.rpm
pg_similarity_14 1.0 el9.x86_64 pigsty 44.2 KiB pg_similarity_14-1.0-2PIGSTY.el9.x86_64.rpm
pg_similarity_14 1.0 el9.aarch64 pigsty 42.5 KiB pg_similarity_14-1.0-2PIGSTY.el9.aarch64.rpm
pg_similarity_14 1.0 el10.x86_64 pigsty 44.5 KiB pg_similarity_14-1.0-2PIGSTY.el10.x86_64.rpm
pg_similarity_14 1.0 el10.x86_64 pgdg 45.7 KiB pg_similarity_14-1.0-3PGDG.rhel10.x86_64.rpm
pg_similarity_14 1.0 el10.aarch64 pigsty 43.0 KiB pg_similarity_14-1.0-2PIGSTY.el10.aarch64.rpm
pg_similarity_14 1.0 el10.aarch64 pgdg 44.2 KiB pg_similarity_14-1.0-3PGDG.rhel10.aarch64.rpm
postgresql-14-similarity 1.0 d12.x86_64 pgdg 99.5 KiB postgresql-14-similarity_1.0-9.pgdg12+1_amd64.deb
postgresql-14-similarity 1.0 d12.aarch64 pgdg 96.8 KiB postgresql-14-similarity_1.0-9.pgdg12+1_arm64.deb
postgresql-14-similarity 1.0 d13.x86_64 pgdg 99.4 KiB postgresql-14-similarity_1.0-9.pgdg13+1_amd64.deb
postgresql-14-similarity 1.0 d13.aarch64 pgdg 96.9 KiB postgresql-14-similarity_1.0-9.pgdg13+1_arm64.deb
postgresql-14-similarity 1.0 u22.x86_64 pgdg 105.4 KiB postgresql-14-similarity_1.0-9.pgdg22.04+1_amd64.deb
postgresql-14-similarity 1.0 u22.aarch64 pgdg 102.8 KiB postgresql-14-similarity_1.0-9.pgdg22.04+1_arm64.deb
postgresql-14-similarity 1.0 u24.x86_64 pgdg 99.3 KiB postgresql-14-similarity_1.0-9.pgdg24.04+1_amd64.deb
postgresql-14-similarity 1.0 u24.aarch64 pgdg 96.4 KiB postgresql-14-similarity_1.0-9.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pg_similarity_13 1.0 el8.x86_64 pigsty 45.4 KiB pg_similarity_13-1.0-2PIGSTY.el8.x86_64.rpm
pg_similarity_13 1.0 el8.aarch64 pigsty 43.8 KiB pg_similarity_13-1.0-2PIGSTY.el8.aarch64.rpm
pg_similarity_13 1.0 el9.x86_64 pigsty 44.1 KiB pg_similarity_13-1.0-2PIGSTY.el9.x86_64.rpm
pg_similarity_13 1.0 el9.aarch64 pigsty 42.5 KiB pg_similarity_13-1.0-2PIGSTY.el9.aarch64.rpm
pg_similarity_13 1.0 el10.x86_64 pigsty 44.5 KiB pg_similarity_13-1.0-2PIGSTY.el10.x86_64.rpm
pg_similarity_13 1.0 el10.x86_64 pgdg 45.6 KiB pg_similarity_13-1.0-3PGDG.rhel10.x86_64.rpm
pg_similarity_13 1.0 el10.aarch64 pigsty 43.0 KiB pg_similarity_13-1.0-2PIGSTY.el10.aarch64.rpm
pg_similarity_13 1.0 el10.aarch64 pgdg 44.1 KiB pg_similarity_13-1.0-3PGDG.rhel10.aarch64.rpm
postgresql-13-similarity 1.0 d12.x86_64 pgdg 99.0 KiB postgresql-13-similarity_1.0-9.pgdg12+1_amd64.deb
postgresql-13-similarity 1.0 d12.aarch64 pgdg 96.3 KiB postgresql-13-similarity_1.0-9.pgdg12+1_arm64.deb
postgresql-13-similarity 1.0 d13.x86_64 pgdg 99.2 KiB postgresql-13-similarity_1.0-9.pgdg13+1_amd64.deb
postgresql-13-similarity 1.0 d13.aarch64 pgdg 96.5 KiB postgresql-13-similarity_1.0-9.pgdg13+1_arm64.deb
postgresql-13-similarity 1.0 u22.x86_64 pgdg 104.9 KiB postgresql-13-similarity_1.0-9.pgdg22.04+1_amd64.deb
postgresql-13-similarity 1.0 u22.aarch64 pgdg 102.2 KiB postgresql-13-similarity_1.0-9.pgdg22.04+1_arm64.deb
postgresql-13-similarity 1.0 u24.x86_64 pgdg 98.6 KiB postgresql-13-similarity_1.0-9.pgdg24.04+1_amd64.deb
postgresql-13-similarity 1.0 u24.aarch64 pgdg 96.0 KiB postgresql-13-similarity_1.0-9.pgdg24.04+1_arm64.deb

Source

Repository
github.com/eulerto/pg_similarity
 Source Tarball
pg_similarity-1.0.tar.gz
 
pig build pkg pg_similarity;		# build rpm / deb with pig

Install

Make sure PGDG and PIGSTY repo available:

pig repo add pgdg pigsty -u   # add both repo and update cache

Install this extension with pig:

pig install pg_similarity;		# install via package name, for the active PG version

pig install pg_similarity -v 18;   # install for PG 18
pig install pg_similarity -v 17;   # install for PG 17
pig install pg_similarity -v 16;   # install for PG 16
pig install pg_similarity -v 15;   # install for PG 15
pig install pg_similarity -v 14;   # install for PG 14
pig install pg_similarity -v 13;   # install for PG 13

Create this extension with:

CREATE EXTENSION pg_similarity;
Last updated on
vectorizesmlar