Re: libpq simple SELECT

David,,

On Wed, Dec 17, 2025 at 1:14 PM David G. Johnston
<david.g.johnston@gmail.com> wrote:
>
> 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.

So what do I do after calling PQexec()? And why is my code running only once?

Thank you.

>
> David J.
>