Re: COPY for CSV documentation - Mailing list pgsql-patches

From Andrew Dunstan
Subject Re: COPY for CSV documentation
Date
Msg-id 1551.24.211.141.25.1081749901.squirrel@www.dunslane.net
Whole thread Raw
In response to Re: COPY for CSV documentation  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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



pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: COPY for CSV documentation
Next
From: "Andrew Dunstan"
Date:
Subject: Re: COPY for CSV documentation