On Fri, Sep 16, 2011 at 21:39, Raghavendra <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
