From: | Ben(dot)Young(at)risk(dot)sungard(dot)com |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: multiline CSV fields |
Date: | 2004-11-30 13:26:38 |
Message-ID: | OF32B80860.F00446F7-ON80256F5C.0049621F-80256F5C.00496265@risk.sungard.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-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.
>
I am normally more of a lurker on these lists, but I thought you had
better know
that when we developed CSV import/export for an application at my last
company
we discovered that Excel can't always even read the CSV that _it_ has
output!
(With embedded newlines a particular problem)
It is far more reliable if you output your data as an HTML table, in which
case it
practically always gets it right. Perhaps Postgres could support this as
an import/
export mechanism as I have found it to be far less error prone than CSV?
Cheers,
Ben Young
> cheers
>
> andrew
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
From | Date | Subject | |
---|---|---|---|
Next Message | Bojidar Mihajlov | 2004-11-30 13:56:21 | Large objects through ODBS |
Previous Message | Marc G. Fournier | 2004-11-30 13:11:44 | Re: [ANNOUNCE] USENET vs Mailing Lists Poll ... |
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2004-11-30 16:05:56 | Re: multiline CSV fields |
Previous Message | Andrew Dunstan | 2004-11-30 13:03:48 | Re: multiline CSV fields |