Postgres Pro
Downloads
Home   >   mailing lists

Re: Trigger - Mailing list pgsql-admin

From Thiemo Kellner
Subject Re: Trigger
Date
Msg-id bc3d2431-e1de-42ff-91a1-4516785b9a5f@gelassene-pferde.biz
Whole thread Raw
In response to [MASSMAIL]Trigger  (Rajesh Kumar <rajeshkumar.dba09@gmail.com>)
Responses Re: Trigger  (Erik Wienhold <ewie@ewie.name>)
List pgsql-admin
Tree view 

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.

pgsql-admin by date:

Previous
From: Rajesh Kumar
Date:
Subject: Re: About Autovacuum Query
Next
From: jaya kumar
Date:
Subject: Re: About Autovacuum Query