Re: Copy Data Question

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Copy Data Question
Дата
Msg-id 9110.1151021467@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Copy Data Question  (Richard Broersma Jr <rabroersma@yahoo.com>)
Ответы Re: Copy Data Question  (<operationsengineer1@yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: Richard Broersma Jr
Дата:
Сообщение: Re: Copy Data Question
Следующее
От: baa@brucealderman.info
Дата:
Сообщение: Re: Copy Data Question