Re: How to import a csv

Thanks a million for the tips , Sean.
I've already fixed it.

Best,
Oliveiros

2007/8/24, Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>:
>
> 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
>

--
"An equation for me has no meaning, unless it represents a thought of God."
- Srinivasa Ramanujan Iyengar