Tino Wildenhain <[EMAIL PROTECTED]> writes: > Tom Lane wrote: > > Tino Wildenhain <[EMAIL PROTECTED]> writes: > >> Ok, but why not just implement this into pg_dump or psql? > >> Why bother the backend with that functionality? > > > > You're not seriously suggesting we reimplement evaluation of WHERE clauses > > on the client side, are you?
No, he's suggesting the client implement COPY formatting after fetching a regular result set. Of course this runs into the same problem other clients have dealing with large result sets. libpq doesn't want to let the client deal with partial results so you have to buffer up the entire result set in memory. 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. -- greg ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq