Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-patches by date

Next:From: Andrew DunstanDate: 2004-04-12 06:26:14
Subject: Re: COPY for CSV documentation
Previous:From: Tom LaneDate: 2004-04-12 03:40:25
Subject: Re: COPY for CSV documentation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group