Generate uuid v4 reset codes using a plpgsql function and a trigger

reset_codes.sql

CREATE EXTENSION IF NOT EXISTS pgcrypto;

CREATE OR REPLACE FUNCTION generate_reset_code()
RETURNS TRIGGER AS $$
BEGIN
  NEW.code = gen_random_uuid();
  RETURN NEW;
END;
$$ language 'plpgsql';

CREATE TRIGGER trigger_generate_reset_code BEFORE CREATE ON reset_codes
FOR EACH ROW EXECUTE PROCEDURE generate_reset_code();