Re: Timestamp of insertion of the row.

From: "Peter Galbavy" <peter(dot)galbavy(at)knowtion(dot)net>
To: "Anagha Joshi" <ajoshi(at)nulinkinc(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Timestamp of insertion of the row.
Date: 2003-06-11 09:32:12
Message-ID: 001c01c32ffc$569168a0$7c28a8c0@cblan.mblox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Stephenson, Adam 2003-06-11 09:33:52 Postgresql on solaris 8
Previous Message Anagha Joshi 2003-06-11 09:12:42 Timestamp of insertion of the row.