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).
Then the IGNORE_DUPLICATE would definitely be the way to go, if speed is
In response to
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|