Re: Timestamp of insertion of the row.

From: "A(dot)Bhuvaneswaran" <bhuvan(at)symonds(dot)net>
To: Anagha Joshi <ajoshi(at)nulinkinc(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Timestamp of insertion of the row.
Date: 2003-06-11 14:16:08
Message-ID: Pine.LNX.4.44.0306111944240.14184-100000@Bhuvan.bksys.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> Hi,
> Is there any way to know data & time when the row is inserted into a
> table?

Add a timestamp field and set the default value as now(). If you wish to
maintain similar value during update, a before trigger could help.

regards,
bhuvaneswaran

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Sidar Lopez Cruz 2003-06-11 14:27:33 link servers
Previous Message Mendola Gaetano 2003-06-11 12:39:16 Re: How can I recover a 6.5.2 databases in a 7.3.3 database without dump files ?