Re: Note that spaces between QUOTE and DELIMITER are included

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Darcy Buskermolen <darcy(at)wavefire(dot)com>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: Note that spaces between QUOTE and DELIMITER are included
Date: 2005-09-05 14:46:20
Message-ID: 431C5A3C.6030402@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Simon Riggs 2005-09-05 19:08:46 Re: statement logging / extended query protocol issues
Previous Message Tom Lane 2005-09-03 16:23:07 Proof-of-concept patch for CREATE LANGUAGE template idea