> For the complete documentation index, see [llms.txt](https://docs.postgresql.tw/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.postgresql.tw/client-interfaces/ecpg/ecpg-sql-commands.md).

# 34.14. Embedded SQL Commands \#

[ALLOCATE DESCRIPTOR](/client-interfaces/ecpg/ecpg-sql-commands/ecpg-sql-allocate-descriptor.md) — 配置 SQL 描述區

[CONNECT](/client-interfaces/ecpg/ecpg-sql-commands/ecpg-sql-connect.md) — 建立資料庫連線

[DEALLOCATE DESCRIPTOR](/client-interfaces/ecpg/ecpg-sql-commands/ecpg-sql-deallocate-descriptor.md) — 釋放 SQL 描述區

[DECLARE](/client-interfaces/ecpg/ecpg-sql-commands/ecpg-sql-declare.md) — 定義游標

[DECLARE STATEMENT](/client-interfaces/ecpg/ecpg-sql-commands/ecpg-sql-declare-statement.md) — 宣告 SQL 陳述式識別字

[DESCRIBE](/client-interfaces/ecpg/ecpg-sql-commands/ecpg-sql-describe.md) — 取得備妥陳述式或結果集的資訊

[DISCONNECT](/client-interfaces/ecpg/ecpg-sql-commands/ecpg-sql-disconnect.md) — 結束資料庫連線

[EXECUTE IMMEDIATE](/client-interfaces/ecpg/ecpg-sql-commands/ecpg-sql-execute-immediate.md) — 動態備妥並執行陳述式

[GET DESCRIPTOR](/client-interfaces/ecpg/ecpg-sql-commands/ecpg-sql-get-descriptor.md) — 從 SQL 描述區取得資訊

[OPEN](/client-interfaces/ecpg/ecpg-sql-commands/ecpg-sql-open.md) — 開啟動態游標

[PREPARE](/client-interfaces/ecpg/ecpg-sql-commands/ecpg-sql-prepare.md) — 備妥要執行的陳述式

[SET AUTOCOMMIT](/client-interfaces/ecpg/ecpg-sql-commands/ecpg-sql-set-autocommit.md) — 設定目前工作階段的自動提交行為

[SET CONNECTION](/client-interfaces/ecpg/ecpg-sql-commands/ecpg-sql-set-connection.md) — 選取資料庫連線

[SET DESCRIPTOR](/client-interfaces/ecpg/ecpg-sql-commands/ecpg-sql-set-descriptor.md) — 在 SQL 描述區設定資訊

[TYPE](/client-interfaces/ecpg/ecpg-sql-commands/ecpg-sql-type.md) — 定義新的資料型別

[VAR](/client-interfaces/ecpg/ecpg-sql-commands/ecpg-sql-var.md) — 定義變數

[WHENEVER](/client-interfaces/ecpg/ecpg-sql-commands/ecpg-sql-whenever.md) — 指定 SQL 陳述式引發特定類別條件時要採取的動作

本節說明所有嵌入式 SQL 特有的 SQL 命令。除非另有說明，也請參閱[SQL 命令](/reference/sql-commands.md)列出的命令；它們同樣可用於嵌入式 SQL。

***

原文：[PostgreSQL 18.6 Documentation](https://www.postgresql.org/docs/18/ecpg-sql-commands.html)（英文原文，待翻譯）


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.postgresql.tw/client-interfaces/ecpg/ecpg-sql-commands.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.