PG_CURSORS

PG_CURSORS displays available cursors.

Table 1 PG_CURSORS columns

Column

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 (that is, it allows rows to be retrieved in a nonsequential manner). If it is, its value is true.

creation_time

Timestamp with time zone

Timestamp of the cursor.