45.51. pg_prepared_statements - [ PostgreSQL 手册 ] - 本地在线手册 - php中文网
最编程
2024-04-02 16:39:53
...
45.51. 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-52. 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.
推荐阅读
-
EditPlus 简介 - [ EditPlus 在线手册 ] - 在线本地手册 - php中文网
-
替代运算符和标记 - [ C 语言中文开发手册 ] - 本地在线手册 - php中文网
-
cargf - [ C 语言中文开发手册 ] - 在线原生手册 - php中文网
-
slaveof - [ Redis 中文开发手册 ] - 本地在线手册 - php中文网
-
zadd - [ Redis 中文开发手册 ] - 本地在线手册 - php中文网
-
JScript 中的操作符 - [ JavaScript 参考手册 ] - 本地在线手册 - php中文网
-
JScript 运行时错误 - [ JavaScript 参考手册 ] - 本地在线手册 - php中文网
-
Microsoft JScript 功能 - ECMA - [ JavaScript 参考手册 ] - 本地在线手册 - php中文网
-
JScript 中的变量 - [ JavaScript 参考手册 ] - 本地在线手册 - php中文网
-
JScript 中的数据类型 - [ JavaScript 参考手册 ] - 本地在线手册 - php中文网