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

Question

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"

jjanes · Accepted Answer · 2021-11-24 15:17:14Z

0

You are trying to import the header row as if it were data. Tell copy to skip the header row, or just don't produce the header to start with.

edited Nov 24, 2021 at 15:17

answered Nov 24, 2021 at 5:31

jjanes

45k5 gold badges39 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

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

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related