Lee Kindness wrote: > <snip> > > WITH ON_DUPLICATE = CONTINUE|TERMINATE (or similar)
I would suggest : WITH ON_DUPLICATE = IGNORE|TERMINATE Or maybe IGNORE_DUPLICATE purely for easier understanding, given there is no present standard nor other databases' syntax to conform to. :) Regards and best wishes, Justin Clift > > need to be added to the COPY command (I hope not)? > > Thanks, > > -- > Lee Kindness, Senior Software Engineer > Concept Systems Limited. -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html