Skip site navigation (1) Skip section navigation (2)

Re: pg_select Equivalent in libpq

From: Christof Petig <christof(at)petig-baender(dot)de>
To: Ecmel Ercan <ecmel(at)linux-turkey(dot)com>
Cc: PostgreSQL <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: pg_select Equivalent in libpq
Date: 2001-09-18 15:35:34
Message-ID: 3BA769C6.AF61644F@petig-baender.de (view raw or flat)
Thread:
Lists: pgsql-interfaces
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)

Christof



In response to

Responses

pgsql-interfaces by date

Next:From: Michael MeskesDate: 2001-09-19 06:43:14
Subject: Re: pg_select Equivalent in libpq
Previous:From: Ecmel ErcanDate: 2001-09-16 17:26:27
Subject: pg_select Equivalent in libpq

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group