Is there a way to get transactionid(xid) from SQL query, or from plpgsql function body? version of PostgreSQL 9.3

http://www.postgresql.org/docs/9.3/static/functions-info.html#FUNCTIONS-TXID-SNAPSHOT <code>txid_current()</code> is probably what you are after.

Getting transactionid(xid) from SQL

http://www.postgresql.org/docs/9.3/static/functions-info.html#FUNCTIONS-TXID-SNAPSHOT

txid_current() is probably what you are after.

189

answered Sep 28 '22 17:09

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!