Diese Seite ist in Ihrer lokalen Sprache noch nicht verfügbar. Wir arbeiten daran, weitere Sprachversionen hinzuzufügen. Vielen Dank für Ihre Unterstützung.

On this page

Show all

PG_CURSORS

Updated on 2024-12-19 GMT+08:00

PG_CURSORS displays 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 (it allows rows to be retrieved in a nonsequential manner). If it is, the value is TRUE. Otherwise, the value is FALSE.

creation_time

timestamp with time zone

Timestamp at which the cursor is declared

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback