Postgres Pro
Downloads
Home   >   mailing lists

Re: LIBPQ: Can we have buffered PGresult (i.e. a retreival bu chuncks?) - Mailing list pgsql-general

From Gregory Stark
Subject Re: LIBPQ: Can we have buffered PGresult (i.e. a retreival bu chuncks?)
Date
Msg-id 87bq9m709o.fsf@oxford.xeocode.com
Whole thread Raw
In response to LIBPQ: Can we have buffered PGresult (i.e. a retreival bu chuncks?)  ("Abraham, Danny" <danny_abraham@bmc.com>)
List pgsql-general
Tree view 
"Abraham, Danny" <danny_abraham@bmc.com> writes:

> Is there a way to break the PGresult array to chunks
> Like Oracle?

There isn't a protocol-level way but there is a way in SQL, use cursors and
"FETCH FORWARD <n>"

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's 24x7 Postgres support!

pgsql-general by date:

Previous
From: Reg Me Please
Date:
Subject: Re: LIBPQ: Can we have buffered PGresult (i.e. a retreival bu chuncks?)
Next
From: Alvaro Herrera
Date:
Subject: Re: LIBPQ: Can we have buffered PGresult (i.e. a retreival bu chuncks?)