Bruce Momjian <pgman@candle.pha.pa.us> writes:
> My bigger issue is that COPY will fail on a single row failure, and
> nothing will be in the table, while INSERT will not.
In theory, there shouldn't be any failures, because the data was known
valid when it was dumped.
Of course, practice often differs from theory, but I wonder whether we
aren't talking about palliating a symptom instead of fixing the real
problem.
regards, tom lane