postgres `insert on conflict update` multiple columns [duplicate]

Question

In this Postgres query,

INSERT INTO TB_PO
SELECT * FROM temporary_table
ON CONFLICT (id) DO UPDATE 
SET id = excluded.id;

Since both the tables tb_po and temporary_table are identical with 26+ columns, is there a way I can specify after the SET, that it will set all columns of the affected row? So that I don't have to manually input each column with SET. thanks

What version of PostgreSQL ?

Gerard H. Pille
– Gerard H. Pille

2018-06-01 08:22:03 +00:00
Commented Jun 1, 2018 at 8:22 — Gerard H. Pille
– Gerard H. Pille, Commented Jun 1, 2018 at 8:22
the PGSQL version is 9.6

coldhands
– coldhands

2018-06-01 08:51:41 +00:00
Commented Jun 1, 2018 at 8:51 — coldhands
– coldhands, Commented Jun 1, 2018 at 8:51

Gerard H. Pille · Accepted Answer · 2018-06-01 08:29:10Z

0

You could avoid some typing by generating your statement based on the results of

SELECT column_name 
   FROM information_schema.columns 
   WHERE table_name = 'TB_PO';

answered Jun 1, 2018 at 8:29

Gerard H. Pille

2,5981 gold badge16 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

postgres `insert on conflict update` multiple columns [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related