all

PostgresQueryBuilder.all(query_mode=<QueryMode.DEFAULT: 'default'>) → Union[Iterable[dict], Iterable[tuple]]

Executes the current query, and returns an iterable cursor (results are loaded as you iterate the cursor)

Usage:

>>> results = PostgresQueryBuilder('people').all()   # Equivalent to ``SELECT * FROM people;``
>>> for r in results:
>>>     print(r['first_name'], r['last_name'], r['phone'])

Return Iterable

A cursor which can be iterated using a for loop, loads rows as you iterate, saving RAM