pg_bulkload sequential

From: Leandro Guimarães <leo(dot)guimaraes(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: pg_bulkload sequential
Date: 2020-11-07 17:28:09
Message-ID: CAJV35FMQ3d5pzC6BFt3aR_zu7+t9h0P4a4rqXCdn_LTTTnFxGw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,
I have a process using pg_bulkload and sometimes i have duplicated keys
in my csv file that pg_bulkload uses.

My question is: pg_bulkload insert it in sequential order ?

Example, if i have the following csv file:

key_1;0.00
key_1;100.00

And use the ON_DUPLICATE_KEEP = NEW in .ctl file, it's guaranteed that
the value 0.00 will be overwritten with 100.00? Or pg_bulkload can't
guarantee this order?

Thanks!
Leandro Guimarães

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-11-07 17:53:43 Re: pg_bulkload sequential
Previous Message Gabi Draghici 2020-11-07 12:17:37 Re: pgagent