Postgres Pro
Downloads
Home   >   mailing lists

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

From Peter Galbavy
Subject Re: Timestamp of insertion of the row.
Date
Msg-id 001c01c32ffc$569168a0$7c28a8c0@cblan.mblox.com
Whole thread Raw
In response to Timestamp of insertion of the row.  ("Anagha Joshi" <ajoshi@nulinkinc.com>)
List pgsql-admin
Tree view 
Anagha Joshi wrote:
> Hi,
> Is there any way to know data & time when the row is inserted into a
> table?

A timestamp column with a default value of 'now' ???

This will only work for inserts and not updates.

Peter

pgsql-admin by date:

Previous
From: "Anagha Joshi"
Date:
Subject: Timestamp of insertion of the row.
Next
From: "Mendola Gaetano"
Date:
Subject: Re: Timestamp of insertion of the row.