Re: COPY permissions problem - Windows XP

Поиск
Список
Период
Сортировка
От john.rylander@gmail.com
Тема Re: COPY permissions problem - Windows XP
Дата
Msg-id 1136247232.633329.125970@g44g2000cwa.googlegroups.com
обсуждение исходный текст
Ответ на Re: COPY permissions problem - Windows XP  ("Jim C. Nasby" <decibel@decibel.org>)
Ответы Re: COPY permissions problem - Windows XP  (john.rylander@gmail.com)
Список pgadmin-support
Jim,

Your reference to \COPY proved extremely useful for me--thanks!

At first, I didn't much pay attention to it, because the portion of the
docs you excerpted focussed on STDIN; but when I read the whole doc set
for the command, it was clear that I could indeed plug in any old file
spec as with the regular COPY command.  When I did that, everything
worked fine.  :)

(Well, when I did that and remembered to use the HEADER parameter, and
managed to properly clean up the CSV file, which strangely had a
trailing comma in every record, which comma bothered Access not at all,
but very understandably bothered PostgreSQL, or perhaps psql.)

Thanks again, Jim.



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

Предыдущее
От: Serge Faucilhon
Дата:
Сообщение: Re: COPY permissions problem - Windows XP
Следующее
От: john.rylander@gmail.com
Дата:
Сообщение: Re: COPY permissions problem - Windows XP