Re: \copy command error

Mark Watson wrote:
>
> *>De :* pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org] *De la part de* Andrew
> Maracini
> >*Envoyé :* 3 août 2009 11:46
> >*À :* pgsql-general@postgresql.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  ',';