fetchone vs. fetchmany with pygres... - Mailing list pgsql-general

From gb@a3design.de
Subject fetchone vs. fetchmany with pygres...
Date
Msg-id Pine.LNX.4.21.0012071601590.367-100000@firebird.mipz.de
Whole thread Raw
List pgsql-general
Hello there!

I am using pygres (postgres-python-interface).

There are two functions for cursors:

cursor.fetchone(): returns one result-row.
cursor.fetchmany(): returns all result-rows.

the problem:
multiple calls of "fetchone" return the same data every call. (It seems to
be written for "non-table-returns" only)
the call of "fetchmany" returns a list of all rows. This is ok but imagine
a very large return-set. You have the whole return-set in the memory
instead of every line one by one.

Is there a solution with something like "fetchone" but with every call to
get the next result-row?

yours
gunter



pgsql-general by date:

Previous
From: Michael Meskes
Date:
Subject: Re: ECPG could not connect to the database.
Next
From: Peter Eisentraut
Date:
Subject: Re: Request for INSTALL help