On Fri, Sep 16, 2011 at 21:39, Raghavendra <raghavendra.rao@xxxxxxxxxxxxxxxx> wrote: > We can get a Transaction ID, but not the transaction timestamp when it > performed. Short answer: You can't. Instead, add a new "timestamptz default now()" column, that will get you the time of the insert. If you want the update time, create a BEFORE UPDATE ON x FOR EACH ROW trigger on this table to update it. Regards, Marti -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
