pg_hashids

pig build pkg pg_hashids;		# build rpm/deb

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

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

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

CREATE EXTENSION pg_hashids;

CREATE EXTENSION pg_hashids;

-- Basic encoding
SELECT id_encode(1001);                                    -- 'jNl'
SELECT id_encode(1234567, 'This is my salt');              -- 'Pdzxp'
SELECT id_encode(1234567, 'This is my salt', 10);          -- 'PlRPdzxpR7'

-- Custom alphabet
SELECT id_encode(1234567, 'This is my salt', 10, 'abcdefghijABCDxFGHIJ1234567890');
-- '3GJ956J9B9'

-- Decoding (use the same salt!)
SELECT id_decode('PlRPdzxpR7', 'This is my salt', 10);     -- 1234567
SELECT id_decode_once('jNl');                               -- 1001
SELECT id_decode_once('Pdzxp', 'This is my salt');          -- 1234567