Breaking News: Grepper is joining You.com. Read the official announcement!

postgres audit table

Jhon Sebastian Lopez answered on May 18, 2022 Popularity 7/10 Helpfulness 2/10

answer postgres audit table

postgres audit table

Comment

create function tg_audit_dist_shard() returns trigger
    language plpgsql
as
$$
DECLARE
    audit_entry int := nextval('audit_entry_seq'::regclass);
BEGIN
    IF (TG_OP = 'INSERT') THEN
        INSERT INTO dist_shard_audit
        VALUES (now(), audit_entry, TG_OP::audit_action, TG_RELID::regclass, NEW.*);
        RETURN NEW;
    ELSIF (TG_OP = 'UPDATE') THEN
        INSERT INTO dist_shard_audit
        VALUES (now(), audit_entry, 'UPDATE_OLD'::audit_action, TG_RELID::regclass, OLD.*),
               (now(), audit_entry, 'UPDATE_NEW'::audit_action, TG_RELID::regclass, NEW.*);
    ELSIF (TG_OP = 'DELETE') THEN
        INSERT INTO dist_shard_audit
        VALUES (now(), audit_entry, TG_OP::audit_action, TG_RELID::regclass, OLD.*);
        RETURN OLD;
    END IF;
    RETURN NULL;
END;
$$;

Popularity 7/10 Helpfulness 2/10 Language sql

Source: heap.io

Tags: audit sql

Link to this answer
Share Copy Link

Contributed on May 18 2022

Jhon Sebastian Lopez

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

postgres audit table

Contents

More Related Answers

postgres audit table

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.