On Fri, 2010-04-02 at 16:28 -0400, Beaver, John E wrote: ... > I know that the query used here could have been a COPY statement, which I > assume would > be better-behaved, but I'm more concerned about the case in which the query > is more complex.
COPY can copy out results of a SELECT query as well. -- Hannu Krosing http://www.2ndQuadrant.com PostgreSQL Scalability and Availability Services, Consulting and Training -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance