what if PQexec() result is toooooo big? - Mailing list pgsql-general

From Aggarwal , Ajay
Subject what if PQexec() result is toooooo big?
Date
Msg-id 913D1DA53416D411835000508BC244C2032C37@cbsvr1.crossbeamsys.com
Whole thread Raw
List pgsql-general
What happens when the PQexec(..) result is too big to return in one single
response message? Say you are reading a table with millions of entries. Is
there a way to write one single PQexec() request but read the result in
chunks :

  "give me the first 500 tuples",
  "give me the next 500",
   and so on... until you read the entire table.

How does postgres handle these situations?

Ajay


pgsql-general by date:

Previous
From: Bruce Guenter
Date:
Subject: Re: replication
Next
From: Adam Haberlach
Date:
Subject: Re: one more word about rules