PostgreSQL update or insert multiple rows

Question

Quick question regarding "upsert" in PostgreSQL:

INSERT INTO CUSTOMERS (id, name, telephone)
VALUES (1, 'John', '930823088'), (2, 'Laura', '008905238')
ON CONFLICT (id) DO UPDATE

now by adding SET I can set the values, but that would be for the entire table. How do define to set the values per row, so that if id 1 exists, the update inserts the first row of values, if 2 exists, it uses the 2nd row?

Any help is greatly appreciated!

user330315 · Accepted Answer · 2020-11-20 11:36:50Z

3

As documented in the manual that's what the excluded pseudo-row is for:

INSERT INTO CUSTOMERS (id, name, telephone)
VALUES (1, 'John', '930823088'), (2, 'Laura', '008905238')
ON CONFLICT (id) DO UPDATE
  set name = excluded.name, 
      telephone = excluded.name;

answered Nov 20, 2020 at 11:36

user330315

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

Collectives™ on Stack Overflow

PostgreSQL update or insert multiple rows

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