Re: Diffs in PG output vs WAL

2022-09-01 Thread Christophe Pettus
> On Sep 1, 2022, at 10:14, V wrote: > I want new/old tuples with pgoutput. how? I assume here you are reading the pgoutput protocol directly. Logical decoding sends out two tuple structures: 1. The replica identity of the row (in the case of update and delete). 2. The new row data (in the c

Diffs in PG output vs WAL

2022-09-01 Thread V
I am playing with pgoutput and logical replication. With wal2json, I could capture the old values before the row was updated. I am unable to figure out how to do that with pgoutput. Does pgoutput even support this? Relevant info from wal2json: > Also, UPDATE/DELETE old row versions can be accesse