Update matching records in database


In my project, I am looking up data in postgres sql database table and create two branches - 1) insert a new record in the table if the record does not exist, and 2) update existing records with data.

I am able to insert new records, however, I am at a loss how to update existing data in the table.

Can someone help with this?


Hi Aatash,

check out these topics: