pgsql.cc 提供对 postgresql.org 官网内容的中文翻译，由 Pigsty 团队维护。
pg_prepared_statements #pg_prepared_statements 视图显示当前会话中所有可用的预备语句。 关于预备语句的更多信息，参见 PREPARE。
pg_prepared_statements 为每个预备语句包含一行。 创建新的预备语句时，会向该视图添加一行；释放预备语句时（例如通过 DEALLOCATE 命令）则会移除该行。
表 45.58. pg_prepared_statements 列
| 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 |
pg_prepared_statements视图是只读的。
译文有误、术语不当或页面显示问题，请到译文仓库 pgsty/pgdoc 报告译文问题。 英文原文本身的问题，请在当前版本的对应页面向上游反馈；上游不再修订已结束维护的版本。