Help Center/
GaussDB/
Developer Guide(Centralized_V2.0-8.x)/
System Catalogs and System Views/
System Views/
Other System Views/
PG_CURSORS
Updated on 2025-08-19 GMT+08:00
PG_CURSORS
PG_CURSORS displays cursors that are currently available.
|
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 |
Parent topic: Other System Views
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.
