Re: Determining when a row was inserted

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: "Eisenhut, Glenn" <glenn(dot)eisenhut(at)bearingpoint(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Determining when a row was inserted
Date: 2005-06-02 12:54:32
Message-ID: 20050602125432.GA9716@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jun 02, 2005 at 06:22:01 +0100,
"Eisenhut, Glenn" <glenn(dot)eisenhut(at)bearingpoint(dot)com> wrote:
>
>
> Folks - hi
>
> Is it possible to determine when a row was inserted into a table using the system catalogs or such.
> I have the situation where I need to find out when a user was added to a user table - the table was not setup with a date to track this.

No. If you want this information, you have to set it up yourself.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gerald D. Anderson 2005-06-02 13:13:39 Re: Old problem needs solution
Previous Message Terry Lee Tucker 2005-06-02 12:50:45 Re: Determining when a row was inserted