Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group