HomeMogDBMogDB StackUqbar
v2.1

Documentation:v2.1

Supported Versions:

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
Copyright © 2011-2024 www.enmotech.com All rights reserved.