To: Pgsql-admin <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
Subject: Trigger
From: Rajesh Kumar <rajeshkumar.dba09@xxxxxxxxx>
Date: Wed, 3 Apr 2024 16:00:17 +0530
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?