pg.ddx.io  pgsql-hackers-win32@postgresql.org mailing list archive  
help / 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