> From: "[email protected]" <[email protected]> > To: PostgreSQL general <[email protected]> > Cc: [email protected] > 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. The column xmin for a row from any table will get you the inserting transaction id, and xmax will get you the deleting (or attempted delete) transaction id. See http://www.postgresql.org/docs/9.0/static/functions-info.html -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
