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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly