Menu
Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

CLOSE

(Optional) Closes all of the free resources that are associated with an open cursor. COMMIT, END, and ROLLBACK automatically close the cursor, so it is not necessary to use the CLOSE command to explicitly close the cursor.

For more information, see DECLARE, FETCH.

Syntax

Copy
CLOSE cursor

Parameters

cursor

Name of the cursor to close.

CLOSE Example

The following commands close the cursor and perform a commit, which ends the transaction:

Copy
close movie_cursor; commit;