Re: Copy Data Question

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

>> 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