Postgres Pro
Downloads
Home   >   mailing lists

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

From A.Bhuvaneswaran
Subject Re: Timestamp of insertion of the row.
Date
Msg-id Pine.LNX.4.44.0306111944240.14184-100000@Bhuvan.bksys.co.in
Whole thread Raw
In response to Timestamp of insertion of the row.  ("Anagha Joshi" <ajoshi@nulinkinc.com>)
List pgsql-admin
Tree view 
> Hi,
> Is there any way to know data & time when the row is inserted into a
> table?

Add a timestamp field and set the default value as now(). If you wish to
maintain similar value during update, a before trigger could help.

regards,
bhuvaneswaran

pgsql-admin by date:

Previous
From: "Mendola Gaetano"
Date:
Subject: Re: How can I recover a 6.5.2 databases in a 7.3.3 database without dump files ?
Next
From: "Sidar Lopez Cruz"
Date:
Subject: link servers