Hi I am getting this error 

ERROR: invalid input syntax for type integer: “Bangalore” CONTEXT: COPY ball, line 2, column inning: “Bangalore” SQL state: 22P02

How can I fix this????

My code-

CREATE TABLE Matches (
id INT,
city int,
date DATE,
player_of_match VARCHAR,
venue VARCHAR,
neutral_venue int,
team1 VARCHAR,
team2 VARCHAR,
toss_winner VARCHAR,
toss_decision VARCHAR,
winner VARCHAR,
result VARCHAR,
result_margin INT,
eliminator VARCHAR,
method VARCHAR,
umpire1 VARCHAR,
umpire2 VARCHAR
);

​Hi I am getting this error ERROR: invalid input syntax for type integer: “Bangalore” CONTEXT: COPY ball, line 2, column inning: “Bangalore” SQL state: 22P02  How can I fix this????My code- CREATE TABLE Matches (id INT,city int,date DATE,player_of_match VARCHAR,venue VARCHAR,neutral_venue int,team1 VARCHAR,team2 VARCHAR,toss_winner VARCHAR,toss_decision VARCHAR,winner VARCHAR,result VARCHAR,result_margin INT,eliminator VARCHAR,method VARCHAR,umpire1 VARCHAR,umpire2 VARCHAR);  Read More

​