strange quoted csv behavior with COPY - Mailing list pgsql-sql

From George Pavlov
Subject strange quoted csv behavior with COPY
Date
Msg-id CCB89282FCE1024EA3DCE687A96A516404C366D8@ehost010-6.exch010.intermedia.net
Whole thread Raw
List 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 by date:

Previous
From: Achilleus Mantzios
Date:
Subject: Re: Does PostgreSQL support job?
Next
From: "padmanabha konkodi"
Date:
Subject: ...