Hi, I am using COPY command to load a data table. When I try to insert a record with a duplicate key, I get the error message "cannot insert a duplicate key into unique index" and no data is loaded into the table. I know that this is the way the COPY command works. Now, is there a way in which I can load a table and if duplicate records do come up, write them to an error file, but still load the other good records into the table? *I think* one of accomplishing this is by performing inserts of individual records, but that would be very slow. any suggestions?
