Re: [HACKERS] Unworkable column delimiter characters for COPY

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: [HACKERS] Unworkable column delimiter characters for COPY
Дата
Msg-id 47752F02.3030807@dunslane.net
обсуждение исходный текст
Ответ на Re: [HACKERS] Unworkable column delimiter characters for COPY  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches

Tom Lane wrote:
> I see that we disallow the CSV quote character from appearing in the
> null_print string, but not the escape character.  Is this
> correct/sensible?

Yes, because:
. nulls are never quoted
. fields containing the quote char must be quoted
. the escape char is only magical inside quoted fields


> If it is correct, maybe the delimiter could also
> match the escape character?
>
>

Yes, probably. Crazy, but I think it's workable. I'll take that test
out, and just make sure that the delimiter is different from the quote.

cheers

andrew

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

Предыдущее
От: Michael Meskes
Дата:
Сообщение: Re: Fix ecpg SQL CONNECT with variable user name
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Doc-patch: PAM authentication fails for local UNIX users