Re: Protocol question regarding Portal vs Cursor
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Dave Cramer <davecramer@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2023-11-07T15:26:42Z
Lists: 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