Re: Trigger

From: Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Trigger
Date: 2024-04-03 14:42:08
Message-ID: bc3d2431-e1de-42ff-91a1-4516785b9a5f@gelassene-pferde.biz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Am 03.04.2024 um 12:30 schrieb Rajesh Kumar:
> I have one table with lot of columns (all vehicle details) and also have
> updated_at column. Everytime there is a change in data, I want to backup
> the original data into a new table?
>
> What's the best option? A function and trigger before update?

I would say so.

In response to

  • Trigger at 2024-04-03 10:30:17 from Rajesh Kumar

Responses

  • Re: Trigger at 2024-04-03 16:05:46 from Erik Wienhold

Browse pgsql-admin by date

  From Date Subject
Next Message jaya kumar 2024-04-03 14:50:04 Re: About Autovacuum Query
Previous Message Rajesh Kumar 2024-04-03 14:38:33 Re: About Autovacuum Query