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
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
Hello All:
I am attempting to import data from a CSV file.
The command I am using is as follows:
copy imagineoptions from 'C:\\Options20081112.csv' DELIMITERS
',' CSV ;
I get the following:
WARNING: nonstandard use of \\ in a string literal
LINE 1: copy imagineopti
