Re: COPY syntax improvement - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: COPY syntax improvement
Date
Msg-id Pine.LNX.4.44.0206202126310.1267-100000@localhost.localdomain
Whole thread Raw
In response to Re: COPY syntax improvement  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
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





pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: SQL99, CREATE CAST, and initdb
Next
From: Bruce Momjian
Date:
Subject: Re: Index Scans become Seq Scans after VACUUM ANALYSE