Updated on 2026-05-29 GMT+08:00

CLOSE

CLOSE frees the resources associated with a cursor.

After a cursor is closed, no subsequent operations are allowed on it.
Cursors that are no longer used should be closed.
Each non-held open cursor should be implicitly closed after the transaction that created the cursor is terminated with COMMIT or ROLLBACK.
A holdable cursor is implicitly closed when the transaction that creates the cursor exits through ROLLBACK.
If the transaction that creates a cursor is committed, the cursor remains open until an explicit CLOSE operation is performed or the client is disconnected.
DWS does not have an explicit OPEN cursor statement. A cursor opens when you define it with the CURSOR command. You can see all available cursors by querying the pg_cursors system view.

     CLOSE { cursor_name | ALL };

**Table 1** CLOSE parameters
Parameter	Description	Value Range
cursor_name	Specifies the name of the cursor to be closed.	Name of an existing cursor.
ALL	Closes all open cursors.	-

Close a cursor.

     CLOSE cursor1;