Invalid input syntax when uploading a csv in pgadmin

Question

This is probably super simple yet i can't figure it out, sorry. I created a simple CSV dataset:

product_id,type,profit,revenue
1,Fruit,18,10
2,Vegetable,14,7
3,Electronics,15,29
4,Cosmetics,5,19
5,Cosmetics,4,21

and a respective table in pgAdmin:

CREATE TABLE dataset.products(
    product_id int PRIMARY KEY,
    type varchar,
    profit numeric,
    revenue numeric
)

then, used the Import/Export data button and uploaded the file. However, every time I do it, I get an error:

ERROR: invalid input syntax for type integer: "product_id"
CONTEXT: COPY products, line 1, column product_id: "product_id"

I tried different data types for this field: numeric, serial, int (spelled also integer), nothing will work. What am I doing wrong?

remove the header (column names) from your csv. It's trying to put the string product_id into an integer column now. — VvdL
– VvdL, Commented Sep 2, 2022 at 12:57

jmvcollaborator · Accepted Answer · 2022-09-15 20:22:20Z

2

In case you receive many CSV files and want to avoid modifying the source file, the import/export data windows allows you to turn on/off the header.

Move the Header switch to the Yes position to include the table header with the data rows. If you include the table header, the first row of the file will contain the column names.

answered Sep 15, 2022 at 20:22

jmvcollaborator

2,5411 gold badge10 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

Invalid input syntax when uploading a csv in pgadmin

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