• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Systems Tables and Views
  5. PG_CURSORS

PG_CURSORS

PG_CURSORS lists the 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

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 at which the cursor is declared