Re: libpq request results

"Magnus Hagander" <[email protected]> Tue, 26 Jul 2005 15:03:49 +0200
Newsgroups gmane.comp.db.postgresql.devel.win32
Message-ID <[email protected]>
> Hi !
>=20
> I hope I choose the correct mailing list and I hope my=20
> question has not been already asked.
> Correct me if I wrong.
> I do not understand something : what is the difference=20
> between this mailing list and the newsgroup : news.postrgesql.org ?

They are mirrored to each other, I beleive. So just different transports
of the same data.


> My question concerning postgre sql libpq :=20

Postgres or PostgreSQL, please, no such thing as postgre.


> Is it possible to ask Postgre engine for a request, then wait=20
> for the end of the request : postgre gives me the total=20
> result rows and then ask for downloading the rows separately ?

Not directly. But what you can do is use a server side cursor, and then
fetch one (or a couple) of rows at a time. It should give you
approximatly the same result. See
http://www.postgresql.org/docs/8.0/static/sql-fetch.html.

//Magnus

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings