[postgis-users] adding csv tables

[Charles Galpin]

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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110810/3c4a6e9d/attachment.html>