Re: [HACKERS] COPY syntax

2002-10-17 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Well, I am the first to agree that the current syntax is not well > designed, but I must admit that I don't quite see what benefit simply > adding "TABLE" would have. I think the idea was that "COPY TABLE ..." could have a new clean syntax without the

Re: [HACKERS] COPY syntax

2002-10-17 Thread Peter Eisentraut
Lee Kindness writes: > Are you serious? You'd like to mess up the COPY syntax even further > for a purely grammatical reason! We already "messed up" the COPY syntax in this release to achieve better user friendliness. I do not think it's unreasonable to review this goal from a variety of angles.

Re: [HACKERS] COPY syntax

2002-10-17 Thread Bruce Momjian
Lee Kindness wrote: > Bruce Momjian writes: > > Peter Eisentraut wrote: > > > Bruce Momjian writes: > > > > > COPY table TO STDOUT WITH BINARY OIDS; > > > > > Shouldn't the "binary", being an adjective, be attached to something? > > > > Uh, it is attached to WITH? > > > Attached to a noun phr

Re: [HACKERS] COPY syntax

2002-10-17 Thread Lee Kindness
Bruce Momjian writes: > Peter Eisentraut wrote: > > Bruce Momjian writes: > > > > COPY table TO STDOUT WITH BINARY OIDS; > > > > Shouldn't the "binary", being an adjective, be attached to something? > > > Uh, it is attached to WITH? > > Attached to a noun phrase, like "mode" or "output". No

Re: [HACKERS] COPY syntax

2002-10-16 Thread Bruce Momjian
Peter Eisentraut wrote: > Bruce Momjian writes: > > > > According to the syntax diagram in the documenation, I can write > > > > > > COPY table TO STDOUT WITH BINARY OIDS; > > > > > > Shouldn't the "binary", being an adjective, be attached to something? > > > > Uh, it is attached to WITH? > > At

Re: [HACKERS] COPY syntax

2002-10-16 Thread Peter Eisentraut
Bruce Momjian writes: > > According to the syntax diagram in the documenation, I can write > > > > COPY table TO STDOUT WITH BINARY OIDS; > > > > Shouldn't the "binary", being an adjective, be attached to something? > > Uh, it is attached to WITH? Attached to a noun phrase, like "mode" or "outpu

Re: [HACKERS] COPY syntax

2002-10-15 Thread Bruce Momjian
Peter Eisentraut wrote: > According to the syntax diagram in the documenation, I can write > > COPY table TO STDOUT WITH BINARY OIDS; > > Shouldn't the "binary", being an adjective, be attached to something? Uh, it is attached to WITH? Seriously, yea, it doesn't read well, but it follows the W

[HACKERS] COPY syntax

2002-10-15 Thread Peter Eisentraut
According to the syntax diagram in the documenation, I can write COPY table TO STDOUT WITH BINARY OIDS; Shouldn't the "binary", being an adjective, be attached to something? -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1

Re: [HACKERS] COPY syntax improvement

2002-06-24 Thread Peter Eisentraut
Bruce Momjian writes: > I thought there were complaints that the old COPY syntax just had too > many features stuffed in too many unusual places, Haven't ever seen one. This command has no precedent in other products, only years of going virtually unchanged in PostgreSQL. Changing it now and a

Re: [HACKERS] COPY syntax improvement

2002-06-24 Thread Bruce Momjian
Well, good points. I know there were some people who wanted a clearer syntax, so I supplied it. Seems you don't. I would like to hear from someone else who doesn't like the improved syntax before I consider changing things back.

[HACKERS] COPY syntax improvement

2002-06-18 Thread Bruce Momjian
I am working on the TODO item: o Change syntax to WITH DELIMITER, (keep old syntax around?) and I have added syntax so COPY can now accept all parameters at the end using WITH: COPY table FROM { 'filename' | stdin } [ [ WITH ] [ BINARY