System Catalogs / System views
pg_cursors
Read the PG 18 manualThe pg_cursors view lists the cursors that are currently available.
Reading PG 18current·documented in 21 of 24 versions, 8.2 to 20
- Kind
- System views
- Columns in this snapshot
- 6
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 6
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
name | text | The name of the cursor |
statement | text | The verbatim query string submitted to declare this cursor |
is_holdable | bool | true if the cursor is holdable (that is, it can be accessed after the transaction that declared the cursor has committed); false otherwise |
is_binary | bool | true if the cursor was declared BINARY; false otherwise |
is_scrollable | bool | true if the cursor is scrollable (that is, it allows rows to be retrieved in a nonsequential manner); false otherwise |
creation_time | timestamptz | The time at which the cursor was declared |
Column history across versions
Version history 14
Definition snapshot: english-manuals:bfe38e315a98bdd9c50bccc1f42… · English manual source