Re: about client-side cursors

On Thu, 4 Feb 2021 at 16:17, Christophe Pettus <xof(at)thebuild(dot)com> wrote:

> Having a single convenience method on the connection object that does the equivalent of a .execute() and a .fetchall() might be useful, though.

You can already do it (in psycopg3):

for record in conn.execute("query"):
# do stuff

or

records = conn.execute("query").fetchall()

or

record = conn.execute("query").fetchone()

The latter examples are two methods, not one, but I think they compose
nicely enough, no? They are pretty orthogonal.

-- Daniele