Search Postgresql Archives

Re: simple COPY FROM issue

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux