Benjamin Krajmalnik wrote:
The problem is that I do not which rows have the problem. Out of a few thousand rows, there are only about 15 rows with the problem. I was wondering if there is some validation which I can run as a script against the table so it wil delete it. How much faster is the copy method as opposed to the insert?
Exponential. Joshua D. Drake -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/