Re: bug in COPY implementation (all versions of Postgres)?

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: bug in COPY implementation (all versions of Postgres)?
Date: 2013-04-06 03:32:57
Message-ID: kjo519$2lv$1@gonzo.reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2013-04-05, Konstantin Izmailov <pgfizm(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jasen Betts 2013-04-06 05:57:41 Re: Need advice to avoid ORDER BY
Previous Message Martín Marqués 2013-04-06 02:59:15 Re: Oracle to PostgreSQL transition?