Re: Timestamp of insertion of the row.

From: "Mendola Gaetano" <mendola(at)bigfoot(dot)com>
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-16 10:56:23
Message-ID: 00ca01c333f5$ed6ccb00$152aa8c0@GMENDOLA2
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Anagha Joshi" <ajoshi(at)nulinkinc(dot)com> wrote:
> Hi All,
> I mean to say ....
> Can I know the time when particular row is inserted into the table? i.e.
> timestamp of insertion of row into the table.

Is not clear what you want:

# begin transaction; // 10:00:00 AM
[ 3 minutes of delay ( computation, others rows inserted, ... ]
# insert row // 10:03:00 AM
# end transaction;

if you use default now() you will have on the time stamp: 10:00:00 AM
if you use default timeofday() you will have on the time stamp: 10:03:00
AM

regards
Gaetano Mendola

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Bruno Wolff III 2003-06-16 11:46:42 Re: Timestamp of insertion of the row.
Previous Message Anagha Joshi 2003-06-16 10:15:28 Re: Timestamp of insertion of the row.