pg.ddx.io pgsql-hackers-win32@postgresql.org mailing list archivehelp / color / mirror / Atom feed
libpq request results 2+ messages / 2 participants [nested] [flat]
* libpq request results @ 2005-07-26 08:46 Michael GUIARD <michael@nestor-tech.com> 0 siblings, 0 replies; 2+ messages in thread From: Michael GUIARD @ 2005-07-26 08:46 UTC (permalink / raw) To: pgsql-hackers-win32 Hi ! I hope I choose the correct mailing list and I hope my question has not been already asked. Correct me if I wrong. I do not understand something : what is the difference between this mailing list and the newsgroup : news.postrgesql.org ? My question concerning postgre sql libpq : I'd like to use database support in my application. My application are written in C++ and oftenly I do not use complex database. So I want to use libpq library to manage db from my applications. When I make a request like SELECT ... the result is downloaded completely through network. The problem is that I have to wait the end of the download before viewing some results (for many result rows and with a poor network connection I have to wait a lot). I tried to use anychronous methos but the problem is the same : my application is not locked during result retreiving (good) but I can't present any results until the download is finished. Is it possible to ask Postgre engine for a request, then wait for the end of the request : postgre gives me the total result rows and then ask for downloading the rows separately ? thanks Mike ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: libpq request results @ 2005-07-26 13:03 Magnus Hagander <mha@sollentuna.net> 0 siblings, 0 replies; 2+ messages in thread From: Magnus Hagander @ 2005-07-26 13:03 UTC (permalink / raw) To: Michael GUIARD <m.guiard@nestor-tech.com>; pgsql-hackers-win32 > Hi ! > > I hope I choose the correct mailing list and I hope my > question has not been already asked. > Correct me if I wrong. > I do not understand something : what is the difference > 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 : Postgres or PostgreSQL, please, no such thing as postgre. > Is it possible to ask Postgre engine for a request, then wait > for the end of the request : postgre gives me the total > 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-07-26 13:03 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2005-07-26 08:46 libpq request results Michael GUIARD <michael@nestor-tech.com> 2005-07-26 13:03 Re: libpq request results Magnus Hagander <mha@sollentuna.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox