> From: "ascot.moss@gmail.com" <ascot.moss@gmail.com>
> To: PostgreSQL general <pgsql-general@postgresql.org>
> Cc: ascot.moss@gmail.com
> Sent: Thursday, 8 August 2013, 14:52
> Subject: [GENERAL] How to find transaction ID
>
> Hi,
>
> I am trying some restore tools, can you advise how to find the latest
> transaction ID in PostgreSQL and the transaction ID at a particular
> "Point-In-Time"?
>
Hmm, it's not clear entirely what you want. Afaik "select txid_current()" should get you the current transaction id.
Thecolumn xmin for a row from any table will get you the inserting transaction id, and xmax will get you the deleting
(orattempted delete) transaction id.
See http://www.postgresql.org/docs/9.0/static/functions-info.html