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
--
Andrew Maracini, GISP/AICP
Superior GIS Solutions LLC
3309 N.Casaloma Dr. #114
Appleton, WI 54913
http://www.superiorgissolutions.com 920-574-2090
906-361-4132 (cell)