On Thu, Nov 13, 2008 at 10:18:56AM -0500, Kevin Duffy wrote: > This worked where E: is on the database server > copy imagineoptions > from 'E:\\ORGDAT~1\\data\\xxxPositions\\20081112_Options.csv' > DELIMITERS ',' CSV ; > > > This does not work fileprint-01 is a different server. > copy imagineoptions > from > \\fileprint-01\Company\xxx\Benchmarking\xxxPositions\20081112_Options.cs > v > DELIMITERS ',' CSV ;
Is this exactly what you entered? if it is, you're missing quotes and escaping. You probably want something more similar to this: COPY imagineoptions FROM E'\\\\fileprint-01\\Company\\xxx\\Benchmarking\\xxxPositions\20081112_Options.csv' WITH CSV; > So the COPY FROM command in Postgres can not handle a URL Postgres doesn't handle URL's, but that's not what you entered. At most, you entered a UNC path (I believe, it's been a *long* time since I had to deal with these under windows) and not a URL. UNC paths always used to be handled transparently by the operating system and didn't need any special handling from normal processes, e.g. a Postgres server. If you could enter the command exactly as you entered it and also include the response back from the server that may help to narrow things down a bit. Sam -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
