Update matching records in database

[aatash]

Hello,

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?

Thanks,
Aatash

[dgudkov]

Hi Aatash,

check out these topics:

Updating a database table

I’m wondering if it is possible to update tables in a database using a transformation. My co-workers rely heavily on Excel and I have them copy data into spreadsheets and use various transformations to insert the data in the database and it works great. Now, I need them to take care of updating data here and there (like the status of an administration or date something closed) and right now they maintain that locally in a spreadsheet which I then manually change in the database. if I could crea…

Updating database rows

The other element I have just thought about is that when updating database rows. In some forum posts, it has been mentioned to delete rows before adding them again. I am worried that I could have users accessing the database and suddenly when they are looking for data it has disappeared. Is there a better way?