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

True if the cursor is holdable (it can be accessed after the transaction that declared the cursor has committed); false otherwise

is_binary

Boolean

Whether the cursor was declared BINARY. If it was, the 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.

creation_time

timestamp with time zone

Timestamp at which the cursor is declared

Feedback
编组 3备份
    openGauss 2024-07-13 01:01:39
    cancel