Re: SQL COPY syntax extension (was: Performance on inserts)

> Could copy be extended to support a more SQL-friendly syntax. like
> COPY tablename FROM VALUES(
>  (x1,y1,z1),
>  (x2,y2,z2),
>  (x3,y3,z3)
> );
> Extending the COPY command would probably be much easier than speeding up
> INSERTS.

That syntax is a lot like a real SQL9x INSERT. Supporting multiple rows
for inserts is probably not that difficult; but since INSERT is used so
much we would have to make sure we don't screw up something else. At the
moment, expanding a line of SQL into multiple internal querytree nodes
is a bit crufty but is possible.
                 - Thomas