pgsql.cc 提供对 postgresql.org 官网内容的中文翻译，由 Pigsty 团队维护。
相对 PostgreSQL 18 的差异；19 beta 4 共收录 185 条 SQL 命令。
PostgreSQL 19 beta 4 尚未正式发布；本页来自对应手册快照，内容仍可能变化。
语法变化按参考页「语法概要」逐行比较；文件改名独立统计，可能同时有语法或正文变化。
| 命令 | 分组 | 变化行数 | 首条新增行 |
|---|---|---|---|
CREATE TABLE | 表与视图 | +7 −4 | CREATE [ persistence_mode ] TABLE [ IF NOT EXISTS ] table_name ( [ |
CREATE TABLE AS | 表与视图 | +2 −1 | CREATE [ persistence_mode ] TABLE [ IF NOT EXISTS ] table_name |
CREATE STATISTICS | 索引与统计 | +1 −0 | ON { column_name | ( expression ) } |
CREATE AGGREGATE | 函数与过程 | +5 −0 | [ , SUPPORT = support_function ] |
CREATE OPERATOR | 类型与运算符 | +0 −1 | — |
CREATE GROUP | 角色与权限 | +0 −4 | — |
CREATE USER | 角色与权限 | +0 −4 | — |
CREATE TRIGGER | 触发器与规则 | +1 −0 | [ NOT DEFERRABLE | [ DEFERRABLE ] [ INITIALLY IMMEDIATE | INITIALLY DEFERRED ] ] [ ENFORCED ] |
CREATE FOREIGN DATA WRAPPER | 外部数据 | +2 −0 | [ CONNECTION connection_function | NO CONNECTION ] |
ALTER FOREIGN DATA WRAPPER | 外部数据 | +2 −0 | [ VALIDATOR validator_function | NO VALIDATOR ] |
CREATE PUBLICATION | 逻辑复制 | +6 −3 | [ FOR { publication_object [, ... ] | publication_all_object [, ... ] } ] |
ALTER PUBLICATION | 逻辑复制 | +7 −4 | ALTER PUBLICATION name SET { publication_object [, ...] | publication_all_object [, ... ] } |
CREATE SUBSCRIPTION | 逻辑复制 | +1 −0 | { SERVER server_name | CONNECTION 'conninfo' } |
ALTER SUBSCRIPTION | 逻辑复制 | +3 −0 | ALTER SUBSCRIPTION name SERVER server_name |
COPY | 查询与数据操作 | +2 −0 | HEADER [ boolean | integer | MATCH ] |
EXPLAIN | 查询与数据操作 | +1 −0 | IO [ boolean ] |
INSERT | 查询与数据操作 | +2 −0 | DO SELECT [ FOR { UPDATE | NO KEY UPDATE | SHARE | KEY SHARE } ] [ WHERE condition ] |
SELECT INTO | 查询与数据操作 | +3 −2 | [ GROUP BY [ ALL | DISTINCT ] grouping_element [, ...] ] |
SET | 会话与参数 | +1 −2 | SET [ SESSION | LOCAL ] configuration_parameter { TO | = } { value [, ...] | DEFAULT } |
CHECKPOINT | 维护 | +3 −0 | CHECKPOINT [ ( option [, ...] ) ] |
VACUUM | 维护 | +1 −2 | FULL [ boolean ] |
DROP MATERIALIZED VIEWCREATE SEQUENCEDROP SEQUENCEALTER TABLEDROP TABLECREATE VIEWDROP VIEWDROP INDEXALTER AGGREGATEDROP AGGREGATECREATE FUNCTIONDROP FUNCTIONDROP LANGUAGEDROP PROCEDUREDROP TRANSFORMDROP COLLATIONALTER DOMAINDROP DOMAINDROP OPERATORDROP OPERATOR CLASSDROP OPERATOR FAMILYDROP TYPECREATE DATABASEDROP DATABASECREATE SCHEMADROP SCHEMAGRANTREVOKEALTER DEFAULT PRIVILEGESDROP OWNEDREASSIGN OWNEDCREATE POLICYDROP EVENT TRIGGERDROP RULEDROP TRIGGERDROP ACCESS METHODDROP EXTENSIONDROP TEXT SEARCH CONFIGURATIONDROP TEXT SEARCH DICTIONARYDROP TEXT SEARCH PARSERDROP TEXT SEARCH TEMPLATEDROP FOREIGN DATA WRAPPERCREATE FOREIGN TABLEALTER FOREIGN TABLEDROP FOREIGN TABLECREATE SERVERDROP SERVERDELETEMERGESELECTUPDATEVALUESCOMMITSET TRANSACTIONNOTIFYSHOWALTER SYSTEMCLUSTERCOMMENT