strange quoted csv behavior with COPY

Поиск
Список
Период
Сортировка
От George Pavlov
Тема strange quoted csv behavior with COPY
Дата
Msg-id CCB89282FCE1024EA3DCE687A96A516404C366D8@ehost010-6.exch010.intermedia.net
обсуждение исходный текст
Список pgsql-sql
what would you expect the following command to insert into column a:

copy foo (a,b) from stdin with csv;
"bar"   , 3
\.

i was expecting to see 'bar', but instead i get 'bar   ' (the spaces
between the double quote and the comma get inserted.

select length(a), * from foo;length |   a    | b
--------+--------+---     6 | bar    | 3

is this by design? what is the use of the quote in this context?

i am on 8.0.6.

george


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

Предыдущее
От: Achilleus Mantzios
Дата:
Сообщение: Re: Does PostgreSQL support job?
Следующее
От: "padmanabha konkodi"
Дата:
Сообщение: ...