| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | Patrick B Kelly <pbk(at)patrickbkelly(dot)org> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: multiline CSV fields |
| Date: | 2004-11-11 17:43:48 |
| Message-ID: | 4193A4D4.7070902@dunslane.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
Patrick B Kelly wrote:
>
> On Nov 10, 2004, at 6:10 PM, Andrew Dunstan wrote:
>
>> The last really isn't an option, because the whole point of CSVs is
>> to play with other programs, and my understanding is that those that
>> understand multiline fields (e.g. Excel) expect them not to be
>> escaped, and do not produce them escaped.
>>
>
> Actually, when I try to export a sheet with multi-line cells from
> excel, it tells me that this feature is incompatible with the CSV
> format and will not include them in the CSV file.
>
>
>
It probably depends on the version. I have just tested with Excel 2000
on a WinXP machine and it both read and wrote these files.
cheers
andrew
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2004-11-11 17:59:06 | Re: MAX/MIN optimization via rewrite (plus query |
| Previous Message | Alvaro Herrera | 2004-11-11 17:38:58 | Re: MAX/MIN optimization via rewrite (plus query rewrites generally) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2004-11-11 19:05:17 | Small patch for regression tests |
| Previous Message | Bruce Momjian | 2004-11-11 17:33:48 | Re: [PATCHES] plperl Safe restrictions |