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@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of brian Sent: Wednesday, November 12, 2008 5:38 PM To: pgsql-general@xxxxxxxxxxxxxx Subject: Re: 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
