I'm loading several ~15 million row files into a table using the COPY command. Apparently one of the rows, about 6 million in, has an invalid entry. This is causing the COPY command to fail, so my question is this: Is there any way to skip invalid rows? Or send them to a separate log file etc to go through later?
I've gone through the docs, but I didn't see anything specific to this. Any information, links, or hints are greatly appreciated.
Cheers!
Bricklen
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
