PG_CURSORS

PG_CURSORS displays 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	Specifies whether the cursor is holdable (that is, whether the cursor can be accessed after the transaction that declared the cursor has committed). If it is, the value is TRUE. Otherwise, the value is FALSE.
is_binary	boolean	Specifies whether the cursor is declared BINARY. If it is, the value is TRUE. Otherwise, the value is FALSE.
is_scrollable	boolean	Specifies 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.