CLOSE SQL - Language Statements CLOSE Close a cursor 1998-04-15 CLOSE cursor 1998-04-15 cursor The name of an open cursor to close. 1998-04-15 CLOSE Message returned if the cursor is successfully closed. NOTICE PerformPortalClose: portal "cursor" not found This warning is given if cursor is not declared or has already been closed. 1998-04-15 CLOSE frees the resources associated with an open cursor. After the cursor is closed, no subsequent operations are allowed on it. A cursor should be closed when it is no longer needed. An implicit close is executed for every open cursor when a transaction is terminated by COMMIT or ROLLBACK. 1998-04-15 PostgreSQL does not have an explicit OPEN cursor statement; a cursor is considered open when it is DECLAREd. Use DECLARE to declare a cursor. Close the cursor liahona: CLOSE liahona; 1998-04-15 CLOSE is fully compatibile with SQL92.