[postgis-users] adding csv tables

[John Callahan]

Of course!  Putting the csv file on the same machine as the database would
help.  Single quotes with forward slashes work fine.    Sorry for wasting
your time...

- John



On Wed, Aug 10, 2011 at 3:33 PM, Charles Galpin <cgalpin at lhsw.com> wrote:

> 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
>
>
>
> _______________________________________________
> 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/bba12517/attachment.html>