base36

pig build pkg pg_base36;		# build rpm/deb

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

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

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

CREATE EXTENSION base36;

CREATE EXTENSION base36;

-- Encode integer to base36
SELECT 1234567::base36;          -- 'qglj'

-- Decode base36 to integer
SELECT 'qglj'::base36::int;     -- 1234567

-- Bigbase36 for larger values
SELECT 9223372036854775807::bigbase36;           -- 'i1y004og0svr'
SELECT 'i1y004og0svr'::bigbase36::bigint;        -- 9223372036854775807