On Tue, Mar 11, 2014 at 12:39:12PM +0000, matshyeq wrote:
> - when using PQsetSingleRowMode() function - does it give an option to
> define how many rows to cache on client's side (like JDBC setFetchSize()
> does) or leaves it at pqlib's discretion?
This option would not make sense as you are not "fetching" anything,
full resultset is being streamed from server over TCP connection.
> - is it/would it be possible to add corresponding option to pgAdmin to
> limit initially (and each subsequently) returned rows in Query Tool by
> custom defined max value?
It could close connection in the middle of resultset but that seems like
bad idea. LIMIT N or FETCH N are better for such task.
--
marko