Re: Before image of selective columns. - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: Before image of selective columns.
Date
Msg-id cd9052dd58672c9bb9718736a7de3de2edfb2a45.camel@cybertec.at
Whole thread Raw
In response to Before image of selective columns.  (Gambhir Singh <gambhir.singh05@gmail.com>)
Responses Re: Before image of selective columns.
List pgsql-admin
On Fri, 2025-01-10 at 15:20 +0530, Gambhir Singh wrote:
> I got a request from my application team that they want the before image of
> selective columns when any delete occurs in DB. They will use this
> information for some audit purposes.

That looks like a job for a trigger; perhaps a statement level trigger
with a transition table.

Yours,
Laurenz Albe



pgsql-admin by date:

Previous
From: Gambhir Singh
Date:
Subject: Before image of selective columns.
Next
From: Scott Ribe
Date:
Subject: Re: Before image of selective columns.