Re: COPY for CSV documentation

From: "Andrew Dunstan" <andrew(at)dunslane(dot)net>
To: <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgman(at)candle(dot)pha(dot)pa(dot)us>, <andrew(at)dunslane(dot)net>, <pgsql-patches(at)postgresql(dot)org>
Subject: Re: COPY for CSV documentation
Date: 2004-04-12 06:05:01
Message-ID: 1551.24.211.141.25.1081749901.squirrel@www.dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Tom Lane said:
>>> COPY a FROM stdin WITH DELIMITER "," QUOTE '"' EQUOTE '"';
>> EQUOTE for embedded quote.
>
> ESCAPE would be better no? It's already a keyword ...

much better.

>
> BTW, don't forget that the syntax options have to be provided in psql's
> \copy as well. Did the patch cover that?
>

No, because it didn't make a syntax change. I admit I didn't test that
though.

cheers

andrew

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Andrew Dunstan 2004-04-12 06:26:14 Re: COPY for CSV documentation
Previous Message Tom Lane 2004-04-12 03:40:25 Re: COPY for CSV documentation