Re: pg_select Equivalent in libpq

Christof Petig wrote:

> Ecmel Ercan wrote:
>
> > At some point, I need to process each tuple returned by the PQexec
> > SELECT query as soon as it is received.  (Actually I like to insert them
> > in a table widget).
> >
> > But when I execute PQExec, all the SELECT result is fetched first.  I
> > have a very big table so I need to insert each row as soon as they are
> > fetched from the server.
> >
> > The pg_select function does this but it is in TCL library.
> >
> > How can I achive the same result in libpq?
>
> I would recommend a cursor. But I don't know how to do that in pq (only
> with ecpg)
>

See Example 1-3 in the libpq documentation:

/** testlibpq3.c Test the C version of Libpq, the Postgres frontend* library. tests the binary cursor interface**
...

Regards,

Antonio Sergio