How to find out in which column an ​​error occurred when writing to the Postgresql database using the psycopg2 Python library?

Question

Python

I have 2 errors:
1) EXCEPTION: ticker_prices> (, DataError('numeric field overflow\nDETAIL: A field with precision 20, scale 5 must round to an absolute value less than 10^15.\n'), )
2)EXCEPTION : ticker_prices> (, DataError('invalid input syntax for integer: "undefined"\nLINE 1: ...741413.0,0.0,0.0,2230,7959,4643,549,0,0,0,0,0,0, 0,\'undefined...\n
There are 100 columns in the database.

Answer 1

the log is enough and so informative
just take a line and look