Hi everyone, I need help with destinations/postgres. I don't know how I can insert or update records with exists primary key? Currently, all data I crawed from HTTP request, are appending to destination with duplicated unique field. I just want to update new data if this primary key is exists and insert if none.

Hi @Hưng Lê are you working on a custom connector? If so, the primary key attribute should be set on the streams and you need to select the incremental + deduped history sync mode during the connection setup.