DataflowTemplate icon indicating copy to clipboard operation
DataflowTemplate copied to clipboard

[Feature Request] Add MERGE command support to the PostgreSQL JDBC sink module

Open h6ah4i opened this issue 1 year ago • 0 comments

WHAT

Adding the INSERT_OR_UPDATE mode support for PostgreSQL JDBC sink.

WHY

Currently, the INSERT_OR_UPDATE mode is only available for MySQL.

Recent versions of PostgreSQL (v15+) support MERGE SQL command that can be used to achieve the INSERT_OR_UPDATE behavior.

ref.) https://www.postgresql.org/docs/current/sql-merge.html

h6ah4i avatar Sep 18 '24 15:09 h6ah4i