How to get Transaction Timestamp ?
| От | Raghavendra |
|---|---|
| Тема | How to get Transaction Timestamp ? |
| Дата | |
| Msg-id | CA+h6AhgBjwy39CKKKJswscdB3F7CqZx+ei0SRX+eQPUuEVuVng@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: How to get Transaction Timestamp ?
|
| Список | pgsql-general |
Respected All,
Can we get the transaction timestamp for INSERT/UPDATE/DELETE ran against table in the database ?
postgres=# create table trx_test(id int, name char(30));
CREATE TABLE
postgres=# insert into trx_test VALUES (1,'AAA');
INSERT 0 1
postgres=# insert into trx_test VALUES (2,'BBB');
INSERT 0 1
postgres=# insert into trx_test VALUES (3,'CCC');
INSERT 0 1
postgres=# select xmin,* from trx_test ;
xmin | id | name
---------+----+--------------------------------
1348711 | 1 | AAA
1348712 | 2 | BBB
1348713 | 3 | CCC
(3 rows)
We can get a Transaction ID, but not the transaction timestamp when it performed.
Kindly advice me.
---
Regards,
Raghavendra
EnterpriseDB Corporation
В списке pgsql-general по дате отправления: