Re: \copy command error

>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 the first two look like:
>Jon,JF,Doe,GIS Coordinator,Miami University,Ohio,Oxford,OH,United
States,10/25/02
>Janet,,Doe,PhD Student and Professional Geologist,York
University,Toronto,ON,Canada,9/25/07
>The table has 9 fields mostly varchar and one date field.
>I'm running 8.3 on Windows Vista Ultimate
>
>thanks.
>
>Andy

Hi Andy,

Your CSV lines have 10 fields (10 comma separated values). Probably, in the
data you are exporting, the City/State is one field, but the comma is being
exported, thus giving you 10 fields. If this is the case, exporting the
City/state field wrapped in quotation marks should do the truck, or use a
different delimiter, like Tab

Mark