Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Getting transactionid(xid) from SQL

Tags:

postgresql

identifier

transactions

plpgsql

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

version of PostgreSQL 9.3

like image 520
Borys Avatar asked Mar 05 '14 12:03

Borys

1 Answers

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

txid_current() is probably what you are after.

like image 189
Richard Huxton Avatar answered Sep 28 '22 17:09

Richard Huxton
Sign in to Comment

Related questions

Calculate a column value during INSERT
Why does the following Postgres SQL query take so long?
How do I find the oldest record in a group using Postgresql?
Converting UTC time field from a POSTGRE/SQL database in SQL
Rails - Boolean field not saved on PostgreSQL / Heroku
PostgreSQL combinations without repetitions
Distinct, count and sort in one sql query
Billions rows in PostgreSql: partition or not to partition?
Identifying results by group and rank using SQL
How to use dj-database-url while connecting with postgresql in heroku using python
PostgreSQL: How to search a list of strings as a table?
Connect PGAdmin3 to Heroku PostgreSQL dedicated database
PostgreSQL - Replace HTML Entities
Do SQL bind parameters affect performance?
if a non-correlated subquery is repeated at several places in the query, can it be cached and the result reused?
Postgres SELECT a concat field and ILIKE it in Rails
Store and retrieve images in Postgresql using Java [closed]
How do I insert into a table from another table by matching on values?
SQL optimisation - Word count in string - Postgresql
PostgreSQL string escaping settings

Donate For Us

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