SYSTEM VIEW · System view
pg_cursors
The pg_cursors view lists the cursors that are currently available. Cursors can be defined in several ways: The pg_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 declared WITH HOLD. Therefore non-holdable cursors are only present in the view until the end of their creating transaction.
Checked column by column against a PostgreSQL 18.6 instance · Raw measurement record ↗
Columns PostgreSQL 18
pg_cursors| COLUMN | TYPE | DESCRIPTION |
|---|---|---|
name |
text |
The name of the cursor |
statement |
text |
The verbatim query string submitted to declare this cursor |
is_holdable |
booleanDocumented as: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 |
booleanDocumented as:bool |
true if the cursor was declared BINARY; false otherwise |
is_scrollable |
booleanDocumented as:bool |
true if the cursor is scrollable (that is, it allows rows to be retrieved in a nonsequential manner); false otherwise |
creation_time |
timestamp with time zoneDocumented as:timestamptz |
The time at which the cursor was declared |
Columns marked "implicit" are not included in SELECT *; some early statistics views are completed from same-version source, and the extra provenance is shown in the column description.
Common system columns 0
System attributes PostgreSQL provides, normally not expanded by SELECT *. Kept separately so they are not mixed in with ordinary columns.
| Columns | Type | attnum |
|---|
Column evolution matrix
Hover a cell for the column type| COLUMN | 9.0 | 9.1 | 9.2 | 9.3 | 9.4 | 9.5 | 9.6 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
name |
|||||||||||||||||
statement |
|||||||||||||||||
is_holdable |
|||||||||||||||||
is_binary |
|||||||||||||||||
is_scrollable |
|||||||||||||||||
creation_time |
9.0 is the coverage baseline; a column already present in the baseline is not marked as added. The matrix aligns columns by name, so a rename appears as the old column removed and a new column added.
Evolution timeline
Changes between adjacent majorsNo column-structure or description change between the covered versions.
Compare any two versions
Pick two versions to see added, removed, and retyped columns. The interactive comparison needs JavaScript; the evolution timeline reads fine without it.