PostgreSQL trigger to historize data

gistfile1.txt

CREATE FUNCTION {{table_name}}_historization_update_trg()
        RETURNS trigger LANGUAGE plpgsql AS $$
BEGIN
    -- we increment the version number                                                                                                                                                                             
    NEW.version = OLD.version + 1;

    INSERT INTO {{schema}}.{{table_name}}_log (id, version, data)
    VALUES (NEW.id, NEW.version, to_json(NEW));

    RETURN NEW;
END;
$$;

--                                                                                                                                                                                                                 
-- Do not log when rows are identical                                                                                                                                                                              
--                                                                                                                                                                                                                 
CREATE TRIGGER {{table_name}}_historization_trg
    BEFORE UPDATE ON {{table_name}}
    FOR EACH ROW
    WHEN (NEW <> OLD)
    EXECUTE PROCEDURE {{table_name}}_historization_update_trg();