Re: How to import a csv

Oliveiros Cristina wrote:
> 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'

You will need to include the column names into which you want to insert
the data.

> 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?

You need to specify the delimiter.  I would suggest looking at the
documentation here:

http://www.postgresql.org/docs/8.2/static/sql-copy.html

Sean

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq