Horton

Re: libpq simple SELECT

David G. Johnston <david.g.johnston@gmail.com>

View thread View on postgr.es
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Igor Korot <ikorot01@gmail.com>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>, "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2025-12-17T21:14:18Z
Lists: pgsql-general 
On Wednesday, December 17, 2025, Igor Korot <ikorot01@gmail.com> wrote:

>
> I hope now my question is clear. I want to know if using CURSR
> is a must.
>

No it is not.  But there isn’t an example of doing so without a cursor
because it is deemed trivial enough that a competent C writer can figure it
out.  In particular, it basically is just the same code as the “fetch”
portion of the example, but the select command is supplied instead of a
fetch command.  Both of those SQL commands result is tuples being generated.

David J.