skip to Main Content

Import of CSV data into PostgreSQL using psycopg3 results in psycopg.errors.InvalidDatetimeFormat

I have a CSV file my_table.csv that looks like the following: "dt_start","my_int_value","my_double_value","dt_version" "2022-01-02 00:00:00",2,2.2,"2022-01-02 00:00:00" "2022-01-03 00:00:00",3,3.3,"2022-01-03 00:00:00" Now I simply want to import this file into a table my_table of my PostgreSQL database from Python using the instructions from…

VIEW QUESTION
Back To Top
Search