PostgreSQL Cursor 10 codes

  1. Home
  2. PostgreSQL
  3. Cursor
1 BACKWARD -2 to then fetch two rows in the forward direction
2 Close a cursor
3 Cursor MOVE FORWARD
4 Declares a cursor named cur_publisher and then uses that cursor to fetch 2 rows
5 FETCH NEXT and FETCH 4
6 FETCH PRIOR
7 Fetches the first two rows in the cur_employee cursor
8 Fetching rows from a cursor
9 Opens a transaction, declares the cur_publishers cursor, and closes it
10 Using cursor in transaction