md5hash

pig build pkg md5hash;		# build rpm/deb

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

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

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

CREATE EXTENSION md5hash;

CREATE EXTENSION md5hash;

CREATE TABLE test_table (
    id md5hash PRIMARY KEY
);

INSERT INTO test_table VALUES ('c4ca4238a0b923820dcc509a6f75849b');

SELECT * FROM test_table
WHERE id = 'c4ca4238a0b923820dcc509a6f75849b';