[sirfz]

That doesn't work well with conflicts tho iirc

[nicwolff]

COPY INTO a temp table and INSERT INTO... SELECT FROM... ON CONFLICT UPDATE...