Re: Protocol question regarding Portal vs Cursor - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Protocol question regarding Portal vs Cursor
Date
Msg-id 123128.1699370802@sss.pgh.pa.us
Whole thread Raw
In response to Protocol question regarding Portal vs Cursor  (Dave Cramer <davecramer@gmail.com>)
Responses Re: Protocol question regarding Portal vs Cursor
List pgsql-hackers
Dave Cramer <davecramer@gmail.com> writes:
> If we use a Portal it is possible to open the portal and do a describe and
> then Fetch N records.

> Using a Cursor we open the cursor. Is there a corresponding describe and a
> way to fetch N records without getting the fields each time. Currently we
> have to send the SQL  "fetch <direction> N" and we get the fields and the
> rows. This seems overly verbose.

Portals and cursors are pretty much the same thing, so why not use
the API that suits you better?

            regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Relids instead of Bitmapset * in plannode.h
Next
From: Peter Eisentraut
Date:
Subject: Re: meson documentation build open issues