MIME-Version: 1.0
From: Dave Cramer <davecramer@gmail.com>
Date: Tue, 7 Nov 2023 06:38:18 -0500
Message-ID: <CADK3HHLJsEN9yBOuTSWHGmUecRCATf_u2GYLBfo-bHsF-NsLwg@mail.gmail.com>
Subject: Protocol question regarding Portal vs Cursor
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000003583c506098e69f5"
Archived-At: <https://www.postgresql.org/message-id/CADK3HHLJsEN9yBOuTSWHGmUecRCATf_u2GYLBfo-bHsF-NsLwg%40mail.gmail.com>
Precedence: bulk

--0000000000003583c506098e69f5
Content-Type: text/plain; charset="UTF-8"

Greetings,

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.

Dave Cramer

--0000000000003583c506098e69f5
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Greetings,<div><br></div><div>If we use a Portal it is pos=
sible to open the portal and do a describe and then Fetch N records.</div><=
div><br></div><div>Using a Cursor we open the cursor. Is there a correspond=
ing describe and a way to fetch N records without=C2=A0getting the fields e=
ach time. Currently we have to send the SQL=C2=A0 &quot;fetch &lt;direction=
&gt; N&quot; and we get the fields and the rows. This seems overly verbose.=
</div><div><br clear=3D"all"><div><div dir=3D"ltr" class=3D"gmail_signature=
" data-smartmail=3D"gmail_signature">Dave Cramer</div></div></div></div>

--0000000000003583c506098e69f5--