PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.
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