Re: COPY for CSVs

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: "Patches (PostgreSQL)" <pgsql-patches(at)postgresql(dot)org>
Subject: Re: COPY for CSVs
Date: 2004-04-09 23:51:26
Message-ID: 407736FE.8080305@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Andrew Dunstan wrote:

> Andrew Dunstan wrote:
>
>>
>> Attached is an undocumented patch that implements COPY for CSVs
>> according to the scheme recently discussed. I believe it handles all
>> the straightforward and perverse cases that were discussed (including
>> multiline fields and partially quoted fields).
>>
>> I have done some light testing on it, but would appreciate some
>> assistance with testing, as well as any useful review comments.
>>
>
> Looking back over the discussion, I see that there was demand for the
> ability to export as well as import CSVs.
>
> That will actually be rather easier to do, so I will revise the patch
> accordingly.
>

version attached that does copy out as well as copy in. I am not sure
about the multibyte stuff, so that needs careful review.

cheers

andrew

Attachment Content-Type Size
csv.patch text/plain 12.2 KB

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Fabien COELHO 2004-04-10 08:47:48 Re: pg_restore ignore error patch
Previous Message Bruce Momjian 2004-04-09 20:41:26 Re: stdin/stdout mismatch for COPY and \copy