# phpman > man > MOVE(7)

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



## NAME
       MOVE - position a cursor

## SYNOPSIS
       MOVE [ _direction_ ] [ FROM | IN ] _cursor_name_

       where _direction_ can be one of:

           NEXT
           PRIOR
           FIRST
           LAST
           ABSOLUTE _count_
           RELATIVE _count_
           _count_
           ALL
           FORWARD
           FORWARD _count_
           FORWARD ALL
           BACKWARD
           BACKWARD _count_
           BACKWARD ALL

## DESCRIPTION
       **MOVE** repositions a cursor without retrieving any data.  **MOVE** works exactly like the **FETCH**
       command, except it only positions the cursor and does not return rows.

       The parameters for the **MOVE** command are identical to those of the **FETCH** command; refer to
       [**FETCH**(7)](https://www.chedong.com/phpMan.php/man/FETCH/7/markdown) for details on syntax and usage.

## OUTPUTS
       On successful completion, a **MOVE** command returns a command tag of the form

           MOVE _count_

       The _count_ is the number of rows that a **FETCH** command with the same parameters would have
       returned (possibly zero).

## EXAMPLES
           BEGIN WORK;
           DECLARE liahona CURSOR FOR SELECT * FROM films;

           -- Skip the first 5 rows:
           MOVE FORWARD 5 IN liahona;
           MOVE 5

           -- Fetch the 6th row from the cursor liahona:
           FETCH 1 FROM liahona;
            code  | title  | did | date_prod  |  kind  |  len
           -------+--------+-----+------------+--------+-------
            P_303 | 48 Hrs | 103 | 1982-10-22 | Action | 01:37
           (1 row)

           -- Close the cursor liahona and end the transaction:
           CLOSE liahona;
           COMMIT WORK;

## COMPATIBILITY
       There is no **MOVE** statement in the SQL standard.

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



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