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