Updated on 2023-10-23 GMT+08:00

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