Based on the default Postgres 16 database image, with hashids.

-- Install the hashids extension CREATE EXTENSION IF NOT EXISTS hashids;

-- Example table using hashids CREATE TABLE users ( id BIGSERIAL PRIMARY KEY, username TEXT NOT NULL, hash_id TEXT GENERATED ALWAYS AS (encode_id(id)) STORED );