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
