Trigger

From: Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Trigger
Date: 2024-04-03 10:30:17
Message-ID: CAJk5Atahkv8YNMJ8nAeE1LRcu5pfWzHRE7PyDmqg5dhNTeKq9A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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?

Responses

  • Re: Trigger at 2024-04-03 14:42:08 from Thiemo Kellner

Browse pgsql-admin by date

  From Date Subject
Next Message Rajesh Kumar 2024-04-03 11:01:03 Re: About Autovacuum Query
Previous Message jaya kumar 2024-04-03 09:55:23 About Autovacuum Query