PG_CURSORS¶
PG_CURSORS displays available cursors.
Column | 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 of the cursor. |