pg_prepared_statements

A system catalogue view listing all prepared statements available in the current session

pg_prepared_statements is a system catalogue view listing all prepared statements available in the current session.

pg_prepared_statements was added in PostgreSQL 8.2.

Definition by PostgreSQL version

pg_prepared_statements (PostgreSQL 13)

                  View "pg_catalog.pg_prepared_statements"
     Column      |           Type           | Collation | Nullable | Default
-----------------+--------------------------+-----------+----------+---------
 name            | text                     |           |          |
 statement       | text                     |           |          |
 prepare_time    | timestamp with time zone |           |          |
 parameter_types | regtype[]                |           |          |
 from_sql        | boolean                  |           |          |
    

Documentation: pg_prepared_statements

pg_prepared_statements (PostgreSQL 12)

                  View "pg_catalog.pg_prepared_statements"
     Column      |           Type           | Collation | Nullable | Default
-----------------+--------------------------+-----------+----------+---------
 name            | text                     |           |          |
 statement       | text                     |           |          |
 prepare_time    | timestamp with time zone |           |          |
 parameter_types | regtype[]                |           |          |
 from_sql        | boolean                  |           |          |
    

Documentation: pg_prepared_statements

pg_prepared_statements (PostgreSQL 11)

                  View "pg_catalog.pg_prepared_statements"
     Column      |           Type           | Collation | Nullable | Default
-----------------+--------------------------+-----------+----------+---------
 name            | text                     |           |          |
 statement       | text                     |           |          |
 prepare_time    | timestamp with time zone |           |          |
 parameter_types | regtype[]                |           |          |
 from_sql        | boolean                  |           |          |
    

Documentation: pg_prepared_statements

pg_prepared_statements (PostgreSQL 10)

                  View "pg_catalog.pg_prepared_statements"
     Column      |           Type           | Collation | Nullable | Default
-----------------+--------------------------+-----------+----------+---------
 name            | text                     |           |          |
 statement       | text                     |           |          |
 prepare_time    | timestamp with time zone |           |          |
 parameter_types | regtype[]                |           |          |
 from_sql        | boolean                  |           |          |
    

Documentation: pg_prepared_statements

pg_prepared_statements (PostgreSQL 9.6)

        View "pg_catalog.pg_prepared_statements"
     Column      |           Type           | Modifiers
-----------------+--------------------------+-----------
 name            | text                     |
 statement       | text                     |
 prepare_time    | timestamp with time zone |
 parameter_types | regtype[]                |
 from_sql        | boolean                  |
    

Documentation: pg_prepared_statements

pg_prepared_statements (PostgreSQL 9.5)

        View "pg_catalog.pg_prepared_statements"
     Column      |           Type           | Modifiers
-----------------+--------------------------+-----------
 name            | text                     |
 statement       | text                     |
 prepare_time    | timestamp with time zone |
 parameter_types | regtype[]                |
 from_sql        | boolean                  |
    

Documentation: pg_prepared_statements

pg_prepared_statements (PostgreSQL 9.4)

        View "pg_catalog.pg_prepared_statements"
     Column      |           Type           | Modifiers
-----------------+--------------------------+-----------
 name            | text                     |
 statement       | text                     |
 prepare_time    | timestamp with time zone |
 parameter_types | regtype[]                |
 from_sql        | boolean                  |
    

Documentation: pg_prepared_statements

pg_prepared_statements (PostgreSQL 9.3)

        View "pg_catalog.pg_prepared_statements"
     Column      |           Type           | Modifiers
-----------------+--------------------------+-----------
 name            | text                     |
 statement       | text                     |
 prepare_time    | timestamp with time zone |
 parameter_types | regtype[]                |
 from_sql        | boolean                  |
    

Documentation: pg_prepared_statements

pg_prepared_statements (PostgreSQL 9.2)

        View "pg_catalog.pg_prepared_statements"
     Column      |           Type           | Modifiers
-----------------+--------------------------+-----------
 name            | text                     |
 statement       | text                     |
 prepare_time    | timestamp with time zone |
 parameter_types | regtype[]                |
 from_sql        | boolean                  |
    

Documentation: pg_prepared_statements

pg_prepared_statements (PostgreSQL 9.1)

        View "pg_catalog.pg_prepared_statements"
     Column      |           Type           | Modifiers
-----------------+--------------------------+-----------
 name            | text                     |
 statement       | text                     |
 prepare_time    | timestamp with time zone |
 parameter_types | regtype[]                |
 from_sql        | boolean                  |
    

Documentation: pg_prepared_statements

pg_prepared_statements (PostgreSQL 9.0)

        View "pg_catalog.pg_prepared_statements"
     Column      |           Type           | Modifiers
-----------------+--------------------------+-----------
 name            | text                     |
 statement       | text                     |
 prepare_time    | timestamp with time zone |
 parameter_types | regtype[]                |
 from_sql        | boolean                  |
    

Documentation: pg_prepared_statements

pg_prepared_statements (PostgreSQL 8.4)

        View "pg_catalog.pg_prepared_statements"
     Column      |           Type           | Modifiers
-----------------+--------------------------+-----------
 name            | text                     |
 statement       | text                     |
 prepare_time    | timestamp with time zone |
 parameter_types | regtype[]                |
 from_sql        | boolean                  |
View definition:
 SELECT p.name, p.statement, p.prepare_time, p.parameter_types, p.from_sql
   FROM pg_prepared_statement() p(name, statement, prepare_time, parameter_types, from_sql);
    

Documentation: pg_prepared_statements

pg_prepared_statements (PostgreSQL 8.3)

        View "pg_catalog.pg_prepared_statements"
     Column      |           Type           | Modifiers
-----------------+--------------------------+-----------
 name            | text                     |
 statement       | text                     |
 prepare_time    | timestamp with time zone |
 parameter_types | regtype[]                |
 from_sql        | boolean                  |
View definition:
 SELECT p.name, p.statement, p.prepare_time, p.parameter_types, p.from_sql
   FROM pg_prepared_statement() p(name text, statement text, prepare_time timestamp with time zone, parameter_types regtype[], from_sql boolean);
    

Documentation: pg_prepared_statements

pg_prepared_statements (PostgreSQL 8.2)

        View "pg_catalog.pg_prepared_statements"
     Column      |           Type           | Modifiers
-----------------+--------------------------+-----------
 name            | text                     |
 statement       | text                     |
 prepare_time    | timestamp with time zone |
 parameter_types | regtype[]                |
 from_sql        | boolean                  |
View definition:
 SELECT p.name, p."statement", p.prepare_time, p.parameter_types, p.from_sql
   FROM pg_prepared_statement() p(name text, "statement" text, prepare_time timestamp with time zone, parameter_types regtype[], from_sql boolean);
    

Documentation: pg_prepared_statements

Change history

Categories

Transactions