Re: Does the psql executable support a "fetch many" approach when dumping large queries to stdout?

From: Hannu Krosing <hannu(at)2ndquadrant(dot)com>
To: "Beaver, John E" <John_Beaver(at)hms(dot)harvard(dot)edu>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Does the psql executable support a "fetch many" approach when dumping large queries to stdout?
Date: 2010-04-02 22:18:08
Message-ID: 1270246688.6482.263.camel@hvost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message John Beaver 2010-04-02 22:18:46 Re: Does the psql executable support a "fetch many" approach when dumping large queries to stdout?
Previous Message Pierre C 2010-04-02 20:43:16 Re: *** PROBABLY SPAM *** Does the psql executable support a "fetch many" approach when dumping large queries to stdout?