Postgres upsert using results from select

Question

I'm trying to upsert with postgres using values from a select. It looks like:

INSERT INTO foo (a, b, c)
SELECT a_, b_, c_
-- hairy sql
ON CONFLICT (...condition...) DO UPDATE
SET "c"=???

On conflict, I want to use one of the values from my select statement, but I can't find the right syntax to alias it. How can I do this with Postgres?

user330315 · Accepted Answer · 2017-06-09 20:41:49Z

16

Use the excluded keyword:

INSERT INTO foo (a, b, c)
SELECT a_, b_, c_
-- hairy sql
ON CONFLICT (...condition...) DO UPDATE
  SET c = excluded.c;

answered Jun 9, 2017 at 20:41

user330315

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

Collectives™ on Stack Overflow

Postgres upsert using results from select

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related