Search Postgresql Archives

pg_bulkload sequential

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux