Re: Bulkloading using COPY - ignore duplicates?

Zeugswetter Andreas SB SD wrote:

>>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...