Postgres Pro
Downloads
Home   >   mailing lists

Implement updated column in all tables - Mailing list pgsql-general

From Andrus
Subject Implement updated column in all tables
Date
Msg-id dajaik$4qn$1@news.hub.org
Whole thread Raw
Responses Re: Implement updated column in all tables
Re: Implement updated column in all tables
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: postmaster link to postgres executable
Next
From: "Andrus"
Date:
Subject: How to force Postgres to calculate MAX(boolean)