# phpman > man > CLOSE(7)

[CLOSE(7)](https://www.chedong.com/phpMan.php/man/CLOSE/7/markdown)                           PostgreSQL 14.23 Documentation                           [CLOSE(7)](https://www.chedong.com/phpMan.php/man/CLOSE/7/markdown)



## NAME
       CLOSE - close a cursor

## SYNOPSIS
       CLOSE { _name_ | ALL }

## DESCRIPTION
       **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.

       Every non-holdable open cursor is implicitly closed when a transaction is terminated by
       **COMMIT** or **ROLLBACK**. A holdable cursor is implicitly closed if the transaction that created it
       aborts via **ROLLBACK**. If the creating transaction successfully commits, the holdable cursor
       remains open until an explicit **CLOSE** is executed, or the client disconnects.

## PARAMETERS
       _name_
           The name of an open cursor to close.

       ALL
           Close all open cursors.

## NOTES
       PostgreSQL does not have an explicit **OPEN** cursor statement; a cursor is considered open when
       it is declared. Use the **DECLARE** statement to declare a cursor.

       You can see all available cursors by querying the pg_cursors system view.

       If a cursor is closed after a savepoint which is later rolled back, the **CLOSE** is not rolled
       back; that is, the cursor remains closed.

## EXAMPLES
       Close the cursor liahona:

           CLOSE liahona;

## COMPATIBILITY
       **CLOSE** is fully conforming with the SQL standard.  **CLOSE** **ALL** is a PostgreSQL extension.

## SEE ALSO
       [**DECLARE**(7)](https://www.chedong.com/phpMan.php/man/DECLARE/7/markdown), [**FETCH**(7)](https://www.chedong.com/phpMan.php/man/FETCH/7/markdown), [**MOVE**(7)](https://www.chedong.com/phpMan.php/man/MOVE/7/markdown)



PostgreSQL 14.23                                2026                                        [CLOSE(7)](https://www.chedong.com/phpMan.php/man/CLOSE/7/markdown)