On Mon, Aug 03, 2009 at 01:18:06PM -0500, erobles wrote:
> 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 ',';
\copy is a special command in psql that does a cop
On Mon, Aug 03, 2009 at 01:25:56PM -0400, Mark Watson wrote:
> Andrew Maracini wrote:
> >GISCI# \copy gisp from 'd:/projects/gisp/gisp.csv' delimiter ','
>
> If this is the case, exporting the
> City/state field wrapped in quotation marks should do the trick
You'll want to use the real CSV parser
Mark Watson wrote:
*>De :* pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@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
>De : pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@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
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 wh
