Re: allow CSV quote in NULL

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: allow CSV quote in NULL
Дата
Msg-id 87vec6p5el.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответ на Re: allow CSV quote in NULL  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: allow CSV quote in NULL  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-patches
"Tom Lane" <tgl@sss.pgh.pa.us> writes:

> Stephen Frost <sfrost@snowman.net> writes:
>>   Please find attached a minor patch to remove the constraints that a
>>   user can't include the delimiter or quote characters in a 'NULL AS'
>>   string when importing CSV files.
>
> This can't really be sane can it?

Including unquoted delimiter characters seems kind of insane. But including
the quote characters or quoted delimiter characters seems reasonable.

The alternative would be interpreting NULL strings after dequoting but that
would leave no way to include the NULL string literally. This solution means
there's no way to include it (if it needs quoting) but only when you specify
it this way.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com


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

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: allow CSV quote in NULL
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: allow CSV quote in NULL