fetchone vs. fetchmany with pygres...

[gunter]

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