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 004801c33000$0606d470$152aa8c0@GMENDOLA2
Whole thread Raw
In response to Timestamp of insertion of the row.  ("Anagha Joshi" <ajoshi@nulinkinc.com>)
List pgsql-admin
"Anagha Joshi" <ajoshi@nulinkinc.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


pgsql-admin by date:

Previous
From: "Peter Galbavy"
Date:
Subject: Re: Timestamp of insertion of the row.
Next
From: "Bruno BAGUETTE"
Date:
Subject: How can I recover a 6.5.2 databases in a 7.3.3 database without dump files ?