Re: Copy Data Question - Mailing list pgsql-novice

From Tom Lane
Subject Re: Copy Data Question
Date
Msg-id 9110.1151021467@sss.pgh.pa.us
Whole thread Raw
In response to Re: Copy Data Question  (Richard Broersma Jr <rabroersma@yahoo.com>)
Responses Re: Copy Data Question  (<operationsengineer1@yahoo.com>)
List pgsql-novice
>> i Start -> Run-> type "cmd" and press enter
>> i then type....
>> COPY t_temp FROM C:\parts.csv'

>> and i get the following error:
>> "The system cannnot find the file specified."

I'll bet doubling the backslash would help.

BTW, Postgres itself would certainly have echoed back the filename it
was trying to open, which would have helped you:

regression=# copy tenk1 from 'C:\parts.csv';
ERROR:  could not open file "C:parts.csv" for reading: No such file or directory

Whatever software actually produced that message needs to be fixed.

            regards, tom lane

pgsql-novice by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: Copy Data Question
Next
From: baa@brucealderman.info
Date:
Subject: Re: Copy Data Question