When using the COPY command in Python or any other scripts, the PostgreSQL does not provide any error logs, and even the PostgreSQL log files do not capture these errors. I believe this feature needs to be enhanced by the PostgreSQL community.