Does QuestDB support server-side PosgreSQL cursors?
Everytime I'm trying to use one I get the following error:
DatabaseError: unexpected token: CURSOR
LINE 1: DECLARE "name_of_cursor" CURSOR WITHOUT HOLD FOR SELECT *
j
Jaromir Hamala
09/30/2022, 7:32 AM
Hello, this is currently not supported.
I believe the Postgres protocol allows clients to use server-side cursors when iterating over a huge result set. It creates a server-side cursor under the hood, but it’s not exposed as user-controlled SQL.