Mark Watson wrote:
>
> *>De :* pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org] *De la part de* Andrew
> Maracini
> >*Envoyé :* 3 août 2009 11:46
> >*À :* pgsql-general(at)postgresql(dot)org
> >*Objet :* [GENERAL] \copy command error
>
> >
>
> >hi,
> >
> >I can't seem to get the \copy command to work.
> >
> >Here's my syntax:
> >
> >GISCI# \copy gisp from 'd:/projects/gisp/gisp.csv' delimiter ','
> >
> >ERROR extra data after last expected column Line 1
> >
> >
> >It is taking all of the fields and grouping them into one field, the
> .csv has about 4700 records, here is what
>
Maybe the error is \c because '\c' is used to connect to another
database.
try the same line without '\' only :
copy gisp from d:/projects/gisp/gisp.csv' delimiters ',';