> On Sep 1, 2022, at 10:14, V <avin...@verloop.io> 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 case of update and insert).
If you want to get the entire content of the old row, you'll need to set the
table as REPLICA IDENTITY FULL. This is something of a hack, and *greatly*
increases the data volume, so you may want to use the subscribing side for the
old tuple (perhaps captured with a trigger).
