Re: LIBPQ: Can we have buffered PGresult (i.e. a retreival by chuncks?)

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: LIBPQ: Can we have buffered PGresult (i.e. a retreival by chuncks?)
Date: 2007-11-25 12:09:00
Message-ID: 20071125120900.GB32482@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Nov 25, 2007 at 05:51:20AM -0600, Abraham, Danny wrote:
> I am referring to client side computing - no SQL changes can be applied.
>
> Is there a LIBPQ dll extension that supports sliding windows like
> management
> Of the *PGresult array?

Sliding windows I don't know. It is possible to stream the results by
setting the socket in non-blocking mode, but if you want windows you
can use server-side cursors, or use a client side that handles this (I
think JDBC can do it, but there are others....)

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
> -- John F Kennedy

In response to

Browse pgsql-general by date

  From Date Subject
Next Message claudia.amorim 2007-11-25 12:38:31 Re: Problems with PostGreSQL and Windows 2003
Previous Message Abraham, Danny 2007-11-25 11:51:20 LIBPQ: Can we have buffered PGresult (i.e. a retreival by chuncks?)