base62

pig build pkg pg_base62;		# build rpm/deb

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

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

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

CREATE EXTENSION base62;

CREATE EXTENSION base62;

-- Encode/decode base62
SELECT 2147483647::base62;          -- '2LKcb1'
SELECT '2LKcb1'::base62::int;      -- 2147483647

-- Bigbase62 for larger values
SELECT 9223372036854775807::bigbase62;           -- 'AzL8n0Y58m7'
SELECT 'AzL8n0Y58m7'::bigbase62::bigint;        -- 9223372036854775807

-- Hugebase62 with bytea conversion
SELECT 'AzL8n0Y58m7AzL8n0Y58'::hugebase62;
SELECT 'AzL8n0Y58m7AzL8n0Y58'::hugebase62::bytea;
SELECT '\x960c06065a6ed8ffff1e7149f40b1800'::bytea::hugebase62;

-- Note: base62 is case-sensitive
SELECT '2lkcb'::base62::int;   -- 40933305
SELECT '2LKCB'::base62::int;   -- 34635195