postgres `insert on conflict update` multiple columns

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 Jun 01 '18 at 08:22 — Gerard H. Pille, Jun 01 '18 at 08:22

score 0 · Answer 1 · answered Jun 01 '18 at 08:29

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 01 '18 at 08:29

Gerard H. Pille

2,528
1
13
17

postgres `insert on conflict update` multiple columns

1 Answers1