CLOSE - Amazon Redshift
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

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 isn't necessary to use the CLOSE command to explicitly close the cursor.

For more information, see DECLARE, FETCH.

Syntax

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:

close movie_cursor; commit;