> From: "ascot.moss@xxxxxxxxx" <ascot.moss@xxxxxxxxx> > To: PostgreSQL general <pgsql-general@xxxxxxxxxxxxxx> > Cc: ascot.moss@xxxxxxxxx > Sent: Thursday, 8 August 2013, 14:52 > Subject: 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
