Cursors

[zenzike]

Rather than executing a whole query at once, it is possible to set up a cursor that encapsulates the query, and then read the query result a few rows at a time. See:

http://www.postgresql.org/docs/8.1/static/plpgsql-cursors.html