The new ON_ERROR option for COPY provides the option to ignore and discard error rows. The default behavior is ON_ERROR stop the import.
ON_ERROR
See COPY.
COPY