Forum Discussion
POSTGRE SQL
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- ...
1. PostGresSQL isn't a Microsoft product, you better should post to a more related forum.
2. The error message doesn't match to your SQL statement
3. If you want to create columns of data type VARCHAR, then you have to define a length, like VARCHAR(50) for a column with max. length = 50 characters.