Re: Protocol question regarding Portal vs Cursor

2023-11-08 Thread Dave Cramer
Dave Cramer On Tue, 7 Nov 2023 at 10:26, Tom Lane wrote: > Dave Cramer 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

Re: Protocol question regarding Portal vs Cursor

2023-11-07 Thread Tom Lane
Dave Cramer 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

Protocol question regarding Portal vs Cursor

2023-11-07 Thread Dave Cramer
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 N" and we