Catalogs: pg_cursors
48.57. pg_cursors
The pg_cursors
view lists the cursors that are currently available. Cursors can be defined in several ways:
-
via the DECLARE statement in SQL
-
via the Bind message in the frontend/backend protocol, as described in Section 49.2.3
-
via the Server Programming Interface (SPI), as described in Section 44.1
The pg_cursors
view displays cursors created by any of these means. Cursors only exist for the duration of the transaction that defines them, unless they have been declared WITH HOLD
. Th