Implement updated column in all tables

From: "Andrus" <noeetasoftspam(at)online(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: Implement updated column in all tables
Date: 2005-07-07 13:25:31
Message-ID: dajaik$4qn$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have the following column in all my tables which contains data of last
update of this row:

updated timestamp without time zone DEFAULT now() NOT NULL,

Hor to force Postgres to update this column automatically with now() value
every time when row is updated ?

I have about 100 tables and don't like to write 100 triggers.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2005-07-07 13:26:35 How to force Postgres to calculate MAX(boolean)
Previous Message Relyea, Mike 2005-07-07 12:21:05 Re: Looking for a good ERD Tool