Re: COPY and duplicates

On Fri, Jul 13, 2001 at 09:40:24AM -0400,
  Ryan Mahoney <ryan@paymentalliance.net> wrote:
> Is it possible for the COPY command to warn about duplicate key violations
> (and not insert them...) but still proceed inserting the rows that do not
> cause a violation?  If not, what is the quickest way to deal with this problem?

You could copy the data into a temporary table and then insert just
run record from a set with the same key into the real table.