PFC <lists(at)peufeu(dot)com> writes:
> > I was also vaguely pondering whether all the DDL commands could be
> > generalized to receive or send COPY formatted data for repeated execution.
> > It would be 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)...;
Does MySQL really let you stream that? Trying to do syntax like that in
Postgres wouldn't work because the parser would try to build up a parse tree
for the whole statement before running the command.
In response to
pgsql-hackers by date
|Next:||From: Jim Nasby||Date: 2006-06-03 14:42:03|
|Subject: Re: 'CVS-Unknown' buildfarm failures?|
|Previous:||From: PFC||Date: 2006-06-03 08:16:33|
|Subject: Re: COPY (query) TO file|