pg_cursors

A system catalogue 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 (commit a5c43b88).

Definition by PostgreSQL version

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.

Categories

System catalogue