products.sql

CREATE TABLE products (
    id BIGSERIAL,
    title TEXT NOT NULL,
    hashid TEXT NOT NULL
);

CREATE FUNCTION products_pre_insert() RETURNS trigger AS $$
    BEGIN
        NEW.hashid := gen_hashid('products_secret_salt_here', 3, NEW.id);
        RETURN NEW;
    END;
$$ LANGUAGE plpgsql;

CREATE TRIGGER products_pre_insert BEFORE INSERT ON products FOR EACH ROW EXECUTE PROCEDURE products_pre_insert();