hashlib

pig build pkg pg_hashlib;		# build rpm/deb

pig repo add pgsql -u   # add both repo and update cache

pig install pg_hashlib;		# install via package name, for the active PG version
pig install hashlib;		# install by extension name, for the current active PG version

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

CREATE EXTENSION hashlib;

SELECT hash_string('hello', 'crc32');
SELECT hash_string('hello', 'murmur3');

SELECT hash_string('hello', 'crc32', 42);

SELECT hash64_string('hello', 'city64');
SELECT hash64_string('hello', 'siphash24');
SELECT hash64_string('hello', 'lookup3');

SELECT hash128_string('hello', 'md5');
SELECT hash128_string('hello', 'city128');
SELECT hash128_string('hello', 'spooky');

SELECT hash_int4(42);        -- 32-bit hash of 32-bit integer
SELECT hash_int8(42::bigint); -- 64-bit hash of 64-bit integer