From: | Franco Bruno Borghesi <franco(at)akyasociados(dot)com(dot)ar> |
---|---|
To: | Christoffer Gurell <orbit(at)0x63(dot)nu> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: retrieving parts of a resultset |
Date: | 2004-02-06 17:31:38 |
Message-ID: | 1076088697.12238.9.camel@taz.oficina.oficina |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I think you should use a cursor; you declare it, and then you fetch the
rows as you need them.
On Fri, 2004-02-06 at 14:04, Christoffer Gurell wrote:
> I want to create a program which displays large tables and makes this possible
> over a slow connection. The problem is that when i do a PQexec the entire
> retultset is transfered.
>
> I would like to make pqsql process the query but only tranfer the the rows i
> ask for when i ask for them. This way i could transfer just the information
> currently displayed and not the entire result.
>
> Is this possible or do i have to do a (create temp table as select ...) and
> then do (select ... limit ..) in this temporary table?
> This would work but i dont think it's a very good solution.
>
> / Christoffer Gurell
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Conway | 2004-02-06 17:33:20 | Re: [GENERAL] dblink - custom datatypes don't work |
Previous Message | Franco Bruno Borghesi | 2004-02-06 17:27:45 | Re: Getting table attributes |