select open change scope Open full search

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

Extensions / AI and vectors

pg_phash

Calculate Hamming distance between decimal-encoded perceptual image hashes

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

Overview

Packagepostgres_phash_hamming
Version1.0
RepositoryUnspecified
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableYes
Stars10
Latest commit2021-06-25
Catalogue updated2026-08-30

Related extensions

See also

imgsmlrImage similarity with haar
bktreeSP-GiST BK-tree index extension for 64-bit perceptual hashes and Hamming-distance searches.
hamming_distanceHamming distance and similarity functions for hexadecimal feature-vector strings.
postpicA PostgreSQL image type with SQL image-processing and metadata functions, backed by GraphicsMagick, plus import/export utilities.
bitstring_helpersHelper C functions and aggregates for PostgreSQL bit varying data.
pg_similaritysupport similarity queries
smlarEffective similarity search
pg_trgmtext similarity measurement and index searching based on trigrams