How to import a csv

["Oliveiros Cristina" <oliveiros(dot)cristina(at)marktest(dot)pt>]

Hi, I am trying to import a file into a table.

 

The file has the form

integer, string

integer, string

 

Table has 5 columns, but I just need to fill the first two, the others can remain blank

 

I've tried COPY table1 FROM 'C:\\file.txt'

 

But PGAdmin ||| complains

with the following :

ERROR: invalid input syntax for integer: " 319613 , Sapo  "
SQL state: 22P02

 

319613 , Sapo is the very first line of the file.

It seems that it is trying to put the pair (integer, string) in the first column alone

 

How can I fix this?

 

Thanx in advance for your help

 

Best,

Oliveiros