Re: Copy Data Question

Поиск
Список
Период
Сортировка
От Richard Broersma Jr
Тема Re: Copy Data Question
Дата
Msg-id 20060626144900.72507.qmail@web31802.mail.mud.yahoo.com
обсуждение исходный текст
Ответ на Re: Copy Data Question  (<operationsengineer1@yahoo.com>)
Список pgsql-novice
> Richard, i'm not sure if you have seen one of my many
> posts today, but OOo was enclosing everything in ''.
> while unintuitive, i finally figured out i could
> delete either of two text delimiter options so that
> the text wasn't delimited - and the problem went away.

Yes that is true.  But for the sake of argument, the copy command sould have worked for values
enclosed in quotes as well.  Perhaps the QUOTE [ AS ] 'quote',  is your case the quote was a "'"
,  possibly you needed to specify QUOTE AS ''''.  Maybe quote escaping was required in the copy
command.

Regards,

Richard Broersma Jr.

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

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: really simple example of c-code and pqlib library
Следующее
От: "Garcia, Joshua"
Дата:
Сообщение: Variable array sizes with PQexecParams