Re: Before image of selective columns.

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Gambhir Singh <gambhir(dot)singh05(at)gmail(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Before image of selective columns.
Date: 2025-01-10 09:55:00
Message-ID: cd9052dd58672c9bb9718736a7de3de2edfb2a45.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Ribe 2025-01-10 13:40:59 Re: Before image of selective columns.
Previous Message Gambhir Singh 2025-01-10 09:50:57 Before image of selective columns.