Re: Timestamp of insertion of the row.

From: "Mendola Gaetano" <mendola(at)bigfoot(dot)com>
To: "Anagha Joshi" <ajoshi(at)nulinkinc(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Timestamp of insertion of the row.
Date: 2003-06-11 09:58:35
Message-ID: 004801c33000$0606d470$152aa8c0@GMENDOLA2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Anagha Joshi" <ajoshi(at)nulinkinc(dot)com> wrote:
> Hi,
> Is there any way to know data & time when the row is inserted into a
> table?

You should define a supplementary field with default value "now()"
this field will contain the transaction start time, if you want have the
real time (if you insert a milion of row inside the same transaction
using now() you'll have the same timestamp ) you should use instead:
"timeofday()".

Regards
Gaetano Mendola

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Bruno BAGUETTE 2003-06-11 12:08:45 How can I recover a 6.5.2 databases in a 7.3.3 database without dump files ?
Previous Message Stephenson, Adam 2003-06-11 09:33:52 Postgresql on solaris 8