Movatterモバイル変換

[0]ホーム
URL:

Facebook
Postgres Pro
Facebook
Downloads
53.6. pg_cursors
Prev UpChapter 53. System ViewsHome Next

53.6. pg_cursors#

Thepg_cursors view lists the cursors that are currently available. Cursors can be defined in several ways:

  • via theDECLARE statement in SQL

  • via the Bind message in the frontend/backend protocol, as described inSection 54.2.3

  • via the Server Programming Interface (SPI), as described inSection 46.1

Thepg_cursors view displays cursors created by any of these means. Cursors only exist for the duration of the transaction that defines them, unless they have been declaredWITH HOLD. Therefore non-holdable cursors are only present in the view until the end of their creating transaction.

Note

Cursors are used internally to implement some of the components ofPostgres Pro, such as procedural languages. Therefore, thepg_cursors view might include cursors that have not been explicitly created by the user.

Table 53.6. pg_cursors Columns

Column Type

Description

nametext

The name of the cursor

statementtext

The verbatim query string submitted to declare this cursor

is_holdablebool

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

is_binarybool

true if the cursor was declaredBINARY;false otherwise

is_scrollablebool

true if the cursor is scrollable (that is, it allows rows to be retrieved in a nonsequential manner);false otherwise

creation_timetimestamptz

The time at which the cursor was declared


Thepg_cursors view is read-only.

Prev Up Next
53.5. pg_config Home 53.7. pg_file_settings
pdfepub
Go to Postgres Pro Standard 16
By continuing to browse this website, you agree to the use of cookies. Go toPrivacy Policy.
[8]ページ先頭
©2009-2025 Movatter.jp