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 <cgal...@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@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > >
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
