Re: Timestamp of insertion of the row. - Mailing list pgsql-admin

From Mendola Gaetano
Subject Re: Timestamp of insertion of the row.
Date
Msg-id 00ca01c333f5$ed6ccb00$152aa8c0@GMENDOLA2
Whole thread Raw
In response to Re: Timestamp of insertion of the row.  ("Anagha Joshi" <ajoshi@nulinkinc.com>)
List pgsql-admin
"Anagha Joshi" <ajoshi@nulinkinc.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





pgsql-admin by date:

Previous
From: "Anagha Joshi"
Date:
Subject: Re: Timestamp of insertion of the row.
Next
From: Bruno Wolff III
Date:
Subject: Re: Timestamp of insertion of the row.