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).
| || ||The identifier of the prepared statement|
| || ||The query string submitted by the client to create this prepared statement. For prepared statements created via SQL, this is the |
| || ||The time at which the prepared statement was created|
| || ||The expected parameter types for the prepared statement in the form of an array of |
| || ||
pg_prepared_statements view is read only.
© 1996–2017 The PostgreSQL Global Development Group
Licensed under the PostgreSQL License.