Importing Csv file to postgres Cloud SQL instance invalid input syntax error

I am trying to import CSV file from my gcs to postgres database in cloud sql, then I connected through pgadmin and make the same columns but with different data types like sale_dollars type in postgres is double precision and in gcs its float,

when I am importing, I am getting this error and I am so confused I have tried to change the data type in pgadmin like real, integer but couldn’t find the type of float.

generic::failed_precondition: ERROR: invalid input syntax for type double precision: "sale_dollars" CONTEXT: COPY iowa_test_table, line 1, column sale_dollars: "sale_dollars"

Source: Python Questions

LEAVE A COMMENT