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