Re: [HACKERS] Bulkloading using COPY - ignore duplicates?

[Thomas Swan]

Zeugswetter Andreas SB SD wrote:

[EMAIL PROTECTED]">

IMHO, you should copy into a temporary table and the do a select 
distinct from it into the table that you want.

Which would be way too slow for normal operation :-(
We are talking about a "fast as possible" data load from a flat file
that may have duplicates (or even data errors, but that 
is another issue).

Andreas

Then the IGNORE_DUPLICATE would definitely be the way to go, if speed is the question...