How can multiple SQL statements be included in
one prepare command? The goal is to reduce chatter between the client and
server by submitting an atomic tranasaction set. My interface is
libpq.
There are several production issues related to the proposed solution. For
example, what happens when the result set exceeds the swap space of the
server or client machine? My original question is how to get a cursor from a
prepared select so a subset of the result can be returned to the client for
How can I execute a prepared query using the
libpq interface? The SQL Prepare documentation talks about select
statements, but where is the documentation on SQL OPEN or some functionally
equivalent libpq API? That is to say how is a cursor generated from a
plan?
Thanks
How can I use a prepared select statement
as mentioned in the documentation on SQL PREPARE. Preparing the
statement is easy, the problem is using the plan to get a cursor. My
assumption is the SQL OPEN command is not documented or there is some
other libpq API to make this happen.
Thanks
