In a perfect world, any and all data you attempt to load into your database would seamlessly and accurately move from point A to point B. Unfortunately, this doesn’t always happen. Occasionally, data fails to load into its destination table, and you’ll probably want to know what didn’t load, and why. Luckily, COPY makes it easy for you to both find out what happened, and hopefully, fix any problems and load your data again. This blog explores why COPY rejects data from being loaded, describes some options you have for handling rejections, and provides you with some best practices.
Continue reading here: