Hi, I am trying to import a file into a table.
The file has the form
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
pgsql-novice by date
|Next:||From: Sean Davis||Date: 2007-08-24 12:14:38|
|Subject: Re: How to import a csv|
|Previous:||From: Tom Lane||Date: 2007-08-24 01:34:22|
|Subject: Re: Truncate table |