meta data for this page
  •  

CLOSE cursor

Available in: PSQL

Added in: 2.0

Description

Closes an open cursor. Any cursors still open when the trigger, stored procedure or EXECUTE BLOCK statement they belong to is exited, will be closed automatically.

Syntax 

CLOSE cursorname;

Example

See DECLARE ... CURSOR.