When i try to copy csv file with pgadmin or just COPY
command it shows me this error
ERROR: nieprawidłowa składnia wejścia dla typu integer: "1,"A Dijiang","M",24,180,80,"China","CHN","1992 Summer","1992","Summer","Barcelona","Basketball","Basketball Men's Basketball",NA"
CONTEXT: COPY olympics_history, line 2, column ID: "1,"A Dijiang","M",24,180,80,"China","CHN","1992 Summer","1992","Summer","Barcelona","Basketball","Ba..."
BŁĄD: nieprawidłowa składnia wejścia dla typu integer: "1,"A Dijiang","M",24,180,80,"China","CHN","1992 Summer","1992","Summer","Barcelona","Basketball","Basketball Men's Basketball",NA"
SQL state: 22P02
(dont know why its in polish but it just means invalid input syntax for integer type)
Here is table schema (ultra basic but i just need it for training)
Column | Type | Collation | Nullable | Default
--------+-------------------+-----------+----------+---------
ID | integer | | |
name | character varying | | |
sex | character varying | | |
age | character varying | | |
height | character varying | | |
weight | character varying | | |
team | character varying | | |
noc | character varying | | |
games | character varying | | |
year | integer | | |
season | character varying | | |
city | character varying | | |
sport | character varying | | |
event | character varying | | |
medal | character varying | | |
In csv file everything seems fine – data is separated by commas etc. I just started learning and have no idea what can be wrong here
Tried putting every header in “”, recreating table
Sebastian Raszkiewicz is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.