PostgreSQL: How to UPSERT table using another table based on two primary keys?

Question

I have a table that has two primary keys, first_name and last_name and also has about 10 other columns. I want to update it using another table that has the exact same schema but many have new values to add or update to the old table. What is the correct SQL query?

The code I have so far is:

UPDATE OLD_DATA AS old
SET val_1 = new.val_1 ,
    val_2 = new.val_2 ,
FROM NEW_DATA AS new
WHERE old.first_name = new.first_name
AND   old.last_name  = new.last_name

But this doesn't add new data, it only updates old data.

Please read meta.stackoverflow.com/questions/285551/… and the accepted answer — user330315
– user330315, Commented Mar 20, 2018 at 14:46

user1367204 · Accepted Answer · 2018-03-19 23:12:46Z

1

Here is the documentation on postgres updates.

update old_data set val_1 = 5 and val_2 = 1
where first_name = 'donald' and last_name = 'duck'

Do the same for each row.

edited Mar 19, 2018 at 23:12

user1367204

4,93713 gold badges56 silver badges83 bronze badges

answered Mar 19, 2018 at 22:56

user3078500

3023 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL: How to UPSERT table using another table based on two primary keys?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related