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 ima
ber 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.
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:
> HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
Try:
COPY imagineoptions FROM E'C:\\Options20081112.csv' ...
or:
COPY imagineoptions FROM 'C:/Options20081112.csv' ...
Kevin Duffy wrote:
Hello All:
I am attempting to import data from a CSV file.
The command I am
