PostgreSQL 9.2.3 Documentation
Prev | Up | Chapter 45. System Catalogs | Next

# 45.59. `pg_prepared_statements`

The `pg_prepared_statements` view displays all the prepared statements that are available in the current session. See PREPARE for more information about prepared statements.

`pg_prepared_statements` contains one row for each prepared statement. Rows are added to the view when a new prepared statement is created and removed when a prepared statement is released (for example, via the DEALLOCATE command).

Table 45-60. `pg_prepared_statements` Columns

Name | Type | Description
--- | --- | ---
`name` | `text` | The identifier of the prepared statement
`statement` | `text` | The query string submitted by the client to create this prepared statement. For prepared statements created via SQL, this is the `PREPARE` statement submitted by the client. For prepared statements created via the frontend/backend protocol, this is the text of the prepared statement itself.
`prepare_time` | `timestamptz` | The time at which the prepared statement was created
`parameter_types` | `regtype[]` | The expected parameter types for the prepared statement in the form of an array of `regtype`. The OID corresponding to an element of this array can be obtained by casting the `regtype` value to `oid`.
`from_sql` | `boolean` | `true` if the prepared statement was created via the `PREPARE` SQL statement; `false` if the statement was prepared via the frontend/backend protocol

The `pg_prepared_statements` view is read only.

Prev | Home | Next
`pg_locks` | Up | `pg_prepared_xacts`