正如在评论中提到的，文档中有一个例子-你可以把它复制粘贴到你的结构上。Demo at db<>fiddle:

create table car(
id int generated by default as identity primary key,
name text,
location text);

create table car_audit(
operation char(1) NOT NULL,
stamp     timestamp NOT NULL,
userid    text      NOT NULL,
id int,
name text,
location text);

CREATE OR REPLACE FUNCTION trf_process_car_audit() RETURNS TRIGGER AS $car_audit$
    BEGIN
        IF (TG_OP = 'DELETE') THEN
            INSERT INTO car_audit SELECT 'D', now(), current_user, OLD.*;
        ELSIF (TG_OP = 'UPDATE') THEN
            INSERT INTO car_audit SELECT 'U', now(), current_user, NEW.*;
        ELSIF (TG_OP = 'INSERT') THEN
            INSERT INTO car_audit SELECT 'I', now(), current_user, NEW.*;
        END IF;
        RETURN NULL;
    END;
$car_audit$ LANGUAGE plpgsql;

CREATE TRIGGER tr_car_audit
AFTER INSERT OR UPDATE OR DELETE ON car
    FOR EACH ROW EXECUTE FUNCTION trf_process_car_audit();

个字符
| 操作|邮票|userId| ID|名称|位置|
| --|--|--|--|--|--|
| 我|2023-12-13 11：47：00.364852| Postgres| 1 |本田|巴黎|
| U| 2023-12-13 11：47：00.364852| Postgres| 1 |现代|巴黎|
| D| 2023-12-13 11：47：00.364852| Postgres| 1 |现代|巴黎|