Title
w

WCKD

09/29/2022, 4:03 PM
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.