PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

SYSTEM CATALOGS / SYSTEM VIEWS

pg_cursors

Read PG 18 manual ↗

The pg_cursors view lists the cursors that are currently available.

Kind: System views
Columns in this snapshot: 6
Definition source: English manual

Columns 6

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

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	20
`name`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`statement`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`is_holdable`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`is_binary`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`is_scrollable`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`creation_time`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●

Definition snapshot: english-manuals:299a3b5210951c23fe99f412aa8… · English manual source