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

In response to

• Re: Bulkloading using COPY - ignore duplicates? at 2001-10-01 14:39:36 from Zeugswetter Andreas SB SD

pgsql-hackers by date

Next:	From: Ken Hirsch	Date: 2001-10-01 14:59:10
	Subject: Re: When scripting, which is better?
Previous:	From: Marc G. Fournier	Date: 2001-10-01 14:40:46
	Subject: Re: Preparation for Beta