I have some questions on PostgreSQL cursors (not PL/pgSQL but the libpq implementation):
What happens when my cursor hit the end of the table? Does it close automatically? I suppose if I declare it as a SCROLLABLE cursor, it should not close at all.
If I have declared a cursor and the session got disconnected, can I reattach back to the cursor if I know the cursor name? I believe this is not possible but I'm not very sure.