PG_PREPARED_STATEMENTS¶
PG_PREPARED_STATEMENTS displays all prepared statements that are available in the current session.
Name | Type | Description |
|---|---|---|
name | text | Identifier of the prepared statement |
statement | text | Query string for creating this prepared statement For prepared statements created through SQL, this is the PREPARE statement submitted by the client. For prepared statements created through the frontend/backend protocol, this is the text of the prepared statement itself. |
prepare_time | timestamp with time zone | Timestamp when the prepared statement is created |
parameter_types | regtype[] | 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 | How a prepared statement was created
|