Re: COPY syntax improvement

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.

---------------------------------------------------------------------------

Peter Eisentraut wrote:
> 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 allowing countless permutations of the key words is going to be
> confusing, IMHO.
> 
> > e.g. delimiter after
> > filename,
> 
> COPY is the only command to use a delimiter, so this can hardly be
> qualified as an "unusual" place.
> 
> > oids after tablename,
> 
> That's because the OIDs are in said table.
> 
> > binary after COPY,
> 
> Which is consistent with DECLARE BINARY CURSOR.
> 
> > NULL after delimiter.
> 
> OK, that order should perhaps be more flexible.
> 
> -- 
> Peter Eisentraut   peter_e@gmx.net
> 
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026