Postgresql 中文操作指南

DEALLOCATE

DEALLOCATE — 取消分配一个已准备的语句

DEALLOCATE — deallocate a prepared statement

Synopsis

DEALLOCATE [ PREPARE ] { name | ALL }

Description

DEALLOCATE 用于取消分配以前一个已准备的 SQL 语句。如果不显式取消分配已准备的语句，则会话结束时会取消分配。

DEALLOCATE is used to deallocate a previously prepared SQL statement. If you do not explicitly deallocate a prepared statement, it is deallocated when the session ends.

有关已准备语句的更多信息，请参见 PREPARE 。

For more information on prepared statements, see PREPARE.

Parameters

  • PREPARE

    • This key word is ignored.

  • name

    • The name of the prepared statement to deallocate.

  • ALL

    • Deallocate all prepared statements.

Compatibility

SQL 标准包含一个 DEALLOCATE 语句，但只用于嵌入式 SQL。

The SQL standard includes a DEALLOCATE statement, but it is only for use in embedded SQL.

See Also

EXECUTE , PREPARE

EXECUTE, PREPARE