Mark Watson wrote:
*>De :* [email protected]
[mailto:[email protected]] *De la part de* Andrew
Maracini
>*Envoyé :* 3 août 2009 11:46
>*À :* [email protected]
>*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 ',';
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
