Re: COPY for CSV documentation

Andrew Dunstan wrote:
> Bruce Momjian said:
> >
> >       COPY tablename [ ( column [, ...] ) ]
> >           TO { 'filename' | STDOUT }
> >           [ [ WITH ]
> >                 [ BINARY ]
> >                 [ OIDS ]
> >                 [ DELIMITER [ AS ] 'delimiter' ]
> >                 [ NULL [ AS ] 'null string' ] ]
> >
> >                 [ CSV [ QUOTE 'quote' ] [ ESCAPE 'escape' ] ]
> >
> > DELIMITER default to tab, except in CSV mode, where it is a comma.
> >
> > That sounds very clear to me.
> >
>
>
> TIMTOWTDI, as we say in the perl world, and we could debate it endlessly.
> This looks fine to me.
>
> a few points:
>
> . ESCAPE should default to same-as-quote
> . in CSV mode, NULL should default to '' - that was in what I sent in.
> . I assume that for now we will enforce the one byte rule for QUOTE and
> ESCAPE as well as for DELIMITER.

Yes, agreed.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073