Lu, Huayi e6fa411af0 DWS DEV 830.201 version

Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>

2024-05-16 07:24:04 +00:00

6.1 KiB

Raw Permalink Blame History

PG_CURSORS

PG_CURSORS displays the cursors that are currently available.

**Table 1** PG_CURSORS columns
Name	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 (it allows rows to be retrieved in a nonsequential manner). If it is, the value is TRUE. Otherwise, the value is FALSE.
creation_time	timestamp with time zone	Timestamp at which the cursor is declared

Parent topic: System Views

6.1 KiB Raw Permalink Blame History

PG_CURSORS

6.1 KiB

Raw Permalink Blame History