Re: COPY command question

Поиск
Список
Период
Сортировка
От Raymond O'Donnell
Тема Re: COPY command question
Дата
Msg-id 49BFBA9D.3020106@iol.ie
обсуждение исходный текст
Ответ на COPY command question  (Ivano Luberti <luberti@archicoop.it>)
Ответы Re: COPY command question  (Ivano Luberti <luberti@archicoop.it>)
Список pgsql-general
On 17/03/2009 14:45, Ivano Luberti wrote:
> Hi all, executing the following command inside pgAdmin on my Windows
> Vista (please avoid comment, I pray you) :
>
> copy anagrafica_import from 'c:\\temp\\anagraficaANIDIs.csv' WITH CSV

Try putting an 'E' in front of the path, like this:

  ....from E'c:\\temp\\anagraficaANIDIs.csv' with csv;

Also, remember that the file needs to be on the same machine as the
server; if you're running pgAdmin on a different machine, this won't work.

HTH,

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

В списке pgsql-general по дате отправления:

Предыдущее
От: Ivano Luberti
Дата:
Сообщение: COPY command question
Следующее
От: "adam.slachta"
Дата:
Сообщение: UPDATE of several columns using SELECT statement