> I was also vaguely pondering whether all the DDL commands could be
> to receive or send COPY formatted data for repeated execution. It would
> neat to be able to prepare an UPDATE with placeholders and stream data
> in COPY
> format as parameters to the UPDATE to execute it thousands or millions of
> times without any protocol overhead or network pipeline stalls.
MySQL already does this for INSERT :
INSERT INTO x (a,b) VALUES (1,2), (3,4), (5,6)...;
> allowing arbitrary SELECT statements as a COPY source
> seems much more powerful and flexible than just supporting COPY FROM
MySQL already does this :
SELECT INTO OUTFILE blah FROM table...
Now in both cases the MySQL syntax sucks but it's still quite practical,
and the INSERT saves some overhead (parsing, acquiring locks...) and is
quite a bit faster than regular INSERT.
In response to
pgsql-hackers by date
|Next:||From: Greg Stark||Date: 2006-06-03 14:22:19|
|Subject: Re: COPY (query) TO file|
|Previous:||From: PFC||Date: 2006-06-03 08:06:03|
|Subject: Re: Generalized concept of modules |