pg_cursors
A system view listing the currently available cursors
pg_cursors
is a system catalogue view listing the currently available cursors.
pg_cursors
was added in PostgreSQL 8.2.
Definition by PostgreSQL version
pg_cursors (PostgreSQL 15)
View "pg_catalog.pg_cursors" Column | Type | Collation | Nullable | Default ---------------+--------------------------+-----------+----------+--------- name | text | | | statement | text | | | is_holdable | boolean | | | is_binary | boolean | | | is_scrollable | boolean | | | creation_time | timestamp with time zone | | |
Documentation: pg_cursors
pg_cursors (PostgreSQL 14)
View "pg_catalog.pg_cursors" Column | Type | Collation | Nullable | Default ---------------+--------------------------+-----------+----------+--------- name | text | | | statement | text | | | is_holdable | boolean | | | is_binary | boolean | | | is_scrollable | boolean | | | creation_time | timestamp with time zone | | |
Documentation: pg_cursors
pg_cursors (PostgreSQL 13)
View "pg_catalog.pg_cursors" Column | Type | Collation | Nullable | Default ---------------+--------------------------+-----------+----------+--------- name | text | | | statement | text | | | is_holdable | boolean | | | is_binary | boolean | | | is_scrollable | boolean | | | creation_time | timestamp with time zone | | |
Documentation: pg_cursors
pg_cursors (PostgreSQL 12)
View "pg_catalog.pg_cursors" Column | Type | Collation | Nullable | Default ---------------+--------------------------+-----------+----------+--------- name | text | | | statement | text | | | is_holdable | boolean | | | is_binary | boolean | | | is_scrollable | boolean | | | creation_time | timestamp with time zone | | |
Documentation: pg_cursors
pg_cursors (PostgreSQL 11)
View "pg_catalog.pg_cursors" Column | Type | Collation | Nullable | Default ---------------+--------------------------+-----------+----------+--------- name | text | | | statement | text | | | is_holdable | boolean | | | is_binary | boolean | | | is_scrollable | boolean | | | creation_time | timestamp with time zone | | |
Documentation: pg_cursors
pg_cursors (PostgreSQL 10)
View "pg_catalog.pg_cursors" Column | Type | Collation | Nullable | Default ---------------+--------------------------+-----------+----------+--------- name | text | | | statement | text | | | is_holdable | boolean | | | is_binary | boolean | | | is_scrollable | boolean | | | creation_time | timestamp with time zone | | |
Documentation: pg_cursors
pg_cursors (PostgreSQL 9.6)
View "pg_catalog.pg_cursors" Column | Type | Modifiers ---------------+--------------------------+----------- name | text | statement | text | is_holdable | boolean | is_binary | boolean | is_scrollable | boolean | creation_time | timestamp with time zone |
Documentation: pg_cursors
pg_cursors (PostgreSQL 9.5)
View "pg_catalog.pg_cursors" Column | Type | Modifiers ---------------+--------------------------+----------- name | text | statement | text | is_holdable | boolean | is_binary | boolean | is_scrollable | boolean | creation_time | timestamp with time zone |
Documentation: pg_cursors
pg_cursors (PostgreSQL 9.4)
View "pg_catalog.pg_cursors" Column | Type | Modifiers ---------------+--------------------------+----------- name | text | statement | text | is_holdable | boolean | is_binary | boolean | is_scrollable | boolean | creation_time | timestamp with time zone |
Documentation: pg_cursors
pg_cursors (PostgreSQL 9.3)
View "pg_catalog.pg_cursors" Column | Type | Modifiers ---------------+--------------------------+----------- name | text | statement | text | is_holdable | boolean | is_binary | boolean | is_scrollable | boolean | creation_time | timestamp with time zone |
Documentation: pg_cursors
pg_cursors (PostgreSQL 9.2)
View "pg_catalog.pg_cursors" Column | Type | Modifiers ---------------+--------------------------+----------- name | text | statement | text | is_holdable | boolean | is_binary | boolean | is_scrollable | boolean | creation_time | timestamp with time zone |
Documentation: pg_cursors
pg_cursors (PostgreSQL 9.1)
View "pg_catalog.pg_cursors" Column | Type | Modifiers ---------------+--------------------------+----------- name | text | statement | text | is_holdable | boolean | is_binary | boolean | is_scrollable | boolean | creation_time | timestamp with time zone |
Documentation: pg_cursors
pg_cursors (PostgreSQL 9.0)
View "pg_catalog.pg_cursors" Column | Type | Modifiers ---------------+--------------------------+----------- name | text | statement | text | is_holdable | boolean | is_binary | boolean | is_scrollable | boolean | creation_time | timestamp with time zone |
Documentation: pg_cursors
pg_cursors (PostgreSQL 8.4)
View "pg_catalog.pg_cursors" Column | Type | Modifiers ---------------+--------------------------+----------- name | text | statement | text | is_holdable | boolean | is_binary | boolean | is_scrollable | boolean | creation_time | timestamp with time zone | View definition: SELECT c.name, c.statement, c.is_holdable, c.is_binary, c.is_scrollable, c.creation_time FROM pg_cursor() c(name, statement, is_holdable, is_binary, is_scrollable, creation_time);
Documentation: pg_cursors
pg_cursors (PostgreSQL 8.3)
View "pg_catalog.pg_cursors" Column | Type | Modifiers ---------------+--------------------------+----------- name | text | statement | text | is_holdable | boolean | is_binary | boolean | is_scrollable | boolean | creation_time | timestamp with time zone | View definition: SELECT c.name, c.statement, c.is_holdable, c.is_binary, c.is_scrollable, c.creation_time FROM pg_cursor() c(name text, statement text, is_holdable boolean, is_binary boolean, is_scrollable boolean, creation_time timestamp with time zone);
Documentation: pg_cursors
pg_cursors (PostgreSQL 8.2)
View "pg_catalog.pg_cursors" Column | Type | Modifiers ---------------+--------------------------+----------- name | text | statement | text | is_holdable | boolean | is_binary | boolean | is_scrollable | boolean | creation_time | timestamp with time zone | View definition: SELECT c.name, c."statement", c.is_holdable, c.is_binary, c.is_scrollable, c.creation_time FROM pg_cursor() c(name text, "statement" text, is_holdable boolean, is_binary boolean, is_scrollable boolean, creation_time timestamp with time zone);
Documentation: pg_cursors
Change history
This view has not been modified since it was added in PostgreSQL 8.2.
- PostgreSQL 8.2
- added (commit a5c43b88)
References
- PostgreSQL documentation: pg_cursors