Re: Note that spaces between QUOTE and DELIMITER are included - Mailing list pgsql-patches

From Andrew Dunstan
Subject Re: Note that spaces between QUOTE and DELIMITER are included
Date
Msg-id 431C5A3C.6030402@dunslane.net
Whole thread Raw
In response to Re: Note that spaces between QUOTE and DELIMITER are included  (Andrew Dunstan <andrew@dunslane.net>)
List 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

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Proof-of-concept patch for CREATE LANGUAGE template idea
Next
From: Martijn van Oosterhout
Date:
Subject: For review: Initial support for COLLATE