> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org