I use single forward slashes just fine, but just in case, this has to be run on 
the same machine as the server afaik.

charles
 
On Aug 10, 2011, at 3:28 PM, John Callahan wrote:

> Sorry if this is more of a postgres question than postgis...
> 
> I'm trying to bring in a CSV table into my postgis database.  I'm using the 
> COPY command but kepe getting the error "No such file or directory."  I'm on 
> Windows and my guess is the error is caused by incorrect syntax.  The online 
> docs mentions that Windows users might need to use the E'' string syntax.  
> What is that and how is it used?  I can't find any good examples. Is the 
> following correct?  Thanks.
> 
> COPY mypgtable FROM 'C:\\data\\projectname\\locations.csv' CSV HEADER;
> 
> 
> - John
> 
> ***********************************
> John Callahan, Research Scientist
> Delaware Geological Survey
> University of Delaware
> URL: http://www.dgs.udel.edu
> *******************************
> _______________________________________________
> postgis-users mailing list
> [email protected]
> http://postgis.refractions.net/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to