Re: simple COPY FROM issue

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 ;


So the COPY FROM command in Postgres can not handle a URL


Thanks for your attention to this matter.


KD

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of brian
Sent: Wednesday, November 12, 2008 5:38 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] simple COPY FROM issue

The file must be on the server. IIRC, with COPY FROM (as opposed to COPY

TO) the path can be relative to the server process dir but it's probably

a good idea to always use an absolute path.

If you wish to copy from the client machine you can use \copy within
psql.

b

Kevin Duffy wrote:
> Hello:
>
>
>
> A follow up question that may clear this all up:
>
>
>
> Is the 'filename' relative to the server machine or the client where
> pgAdmin is running?
>
>
>
>
>
> Kevin Duffy
>
> WR Capital Management
>
> 40 Signal Rd
>
> Stamford, CT
>
> 203-504-6221
>
>
>
>

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general