Relative Content

Tag Archive for postgresqlpgadmin-4

process failed while importing csv file in pgadmin 4

I am trying to import a csv file (CovidDeaths.csv) into pgadmin4. While importing it, I am getting the error which I have attached.error while importing
here is the link to csv file:
https://drive.google.com/file/d/1Mu6Hv8YtlPsKnFQleT6-ZcQgfDQYY2Sg/view

Invalid input syntax error when importing CSV file into PGAdmin4

enter image description hereI am trying to import a csv file into PGAdmin 4. I think the error I am receiving is related to null values (The value at line 1703 was originally not a proper date). Nulls should be acceptable in this column, in that I did not explicitly click “Not null” when setting up the table. I’ve tried using the “copy” method and deleting the values from the original file with no luck. Here is the error message in case my image does not appear: