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

Re: multiline CSV fields

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: multiline CSV fields
Date: 2004-11-30 13:03:48
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackerspgsql-patches

Greg Stark wrote:

>Personally I find the current CSV support inadequate. It seems pointless to
>support CSV if it can't load data exported from Excel, which seems like the
>main use case. 

OK, I'm starting to get mildly annoyed now. We have identified one 
failure case connected with multiline fields. Even in the multiline 
case, I expect that the embedded newlines will usually match those of 
the CSV file, in which case there will be no failure. It's a very big 
step from there to the far more general "can't load data exported from 
Excel". Or did you have some other limitation in mind?

FWIW, I don't make a habit of using multiline fields in my spreadsheets 
- and some users I have spoken to aren't even aware that you can have 
them at all.



In response to


pgsql-hackers by date

Next:From: Marc G. FournierDate: 2004-11-30 13:11:44
Subject: Re: [ANNOUNCE] USENET vs Mailing Lists Poll ...
Previous:From: Vince VielhaberDate: 2004-11-30 12:55:54
Subject: Re: Opinions on Usenet ...

pgsql-patches by date

Next:From: Ben.YoungDate: 2004-11-30 13:26:38
Subject: Re: multiline CSV fields
Previous:From: Kris JurkaDate: 2004-11-30 12:27:40
Subject: Re: multiline CSV fields

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