Re: Note that spaces between QUOTE and DELIMITER are included

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: Note that spaces between QUOTE and DELIMITER are included
Дата
Msg-id 431C5A3C.6030402@dunslane.net
обсуждение исходный текст
Ответ на Re: Note that spaces between QUOTE and DELIMITER are included  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-patches

I wrote:

>
>
> In CSV mode all characters are significant. A quoted value surrounded
> by white space, or any characters other than <literal>DELIMITER</>,
> will include those characters. This can cause errors if  you import
> data from a system that pads CSV lines with white space out to some
> fixed width. If such a situation arises you might need to preprocess
> the CSV file to remove the trailing white space, before importing the
> data into Postgres.
>
>

Patch applied with pretty much this wording.

cheers

andrew

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Proof-of-concept patch for CREATE LANGUAGE template idea
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: For review: Initial support for COLLATE