Re: bug in COPY implementation (all versions of Postgres)? - Mailing list pgsql-general

From Jasen Betts
Subject Re: bug in COPY implementation (all versions of Postgres)?
Date
Msg-id kjo519$2lv$1@gonzo.reversiblemaps.ath.cx
Whole thread Raw
In response to bug in COPY implementation (all versions of Postgres)?  (Konstantin Izmailov <pgfizm@gmail.com>)
List pgsql-general
On 2013-04-05, Konstantin Izmailov <pgfizm@gmail.com> wrote:
>
> 2. Insert value 'Galaxy\040Tab' using command COPY TEST(description) FROM
> stdin WITH DELIMITER '|' CSV.
>
> The following error is returned: value too long for type character
> varying(10)

CSV is essentially a binary format. there is no ecaping in CSV (except
quotes are doubled inside quoted values)

In CSV format \040 is 4 characters.

--
⚂⚃ 100% natural

pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Using varchar primary keys.
Next
From: Jasen Betts
Date:
Subject: Re: Need advice to avoid ORDER BY