PG_CURSORS

PG_CURSORS displays the cursors that are currently available.

Table 1 PG_CURSORS columns

Name

Type

Description

name

text

Cursor name

statement

text

Query statement when the cursor is declared to change

is_holdable

boolean

Whether the cursor is holdable (that is, it can be accessed after the transaction that declared the cursor has committed). If it is, its value is true.

is_binary

boolean

Whether the cursor was declared BINARY. If it was, its value is true.

is_scrollable

boolean

Whether the cursor is scrollable (it allows rows to be retrieved in a nonsequential manner). If it is, the value is TRUE. Otherwise, the value is FALSE.

creation_time

timestamp with time zone

Timestamp at which the cursor is declared