On Thu, Mar 18, 2021 at 2:03 PM Stepan Yankevych <stepan_yankev...@epam.com> wrote:
> Hi All! > > > > Hopefully I’m using correct mail list > > If not please show me right direction 😊 > > > > I’m quite struggling without native Change Data Capture feature in > PostgreSQL. > > > > That would be great to implement it, possibly in not so complicated way. > > > > Can Logical replication be a little be modified or reused to do not > replicate data into destination table as is but to insert each change into > “change table” (like in oracle 11 CDC)? > > That change table should have at lease few additional columns > > - Operation (I/D/U) > - txid > - Commit_time_stamp > > If you look at logical decoding, that's basically what you have, isn't it? It won't go into a table, but you can consume it into one if you want. Look at for example wal2json for examples of how to consume it -- but the system is pluggable so you can build your own or use one of the others available plugins. -- Magnus Hagander Me: https://www.hagander.net/ <http://www.hagander.net/> Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>
