pgsql.cc 提供对 postgresql.org 官网内容的中文翻译，由 Pigsty 团队维护。
相对 PostgreSQL 17 的差异；18 共收录 183 条 SQL 命令。
语法变化按参考页「语法概要」逐行比较；文件改名独立统计，可能同时有语法或正文变化。
| 命令 | 分组 | 变化行数 | 首条新增行 |
|---|---|---|---|
CREATE SEQUENCE | 表与视图 | +2 −1 | [ [ NO ] CYCLE ] |
ALTER SEQUENCE | 表与视图 | +2 −1 | [ [ NO ] CYCLE ] |
CREATE TABLE | 表与视图 | +10 −0 | { NOT NULL [ NO INHERIT ] | |
ALTER TABLE | 表与视图 | +12 −0 | ALTER CONSTRAINT constraint_name [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ] [ ENFORCED | NOT ENFORCED ] |
ALTER DEFAULT PRIVILEGES | 角色与权限 | +10 −0 | TO { [ GROUP ] role_name | PUBLIC } [, ...] [ WITH GRANT OPTION ] |
CREATE FOREIGN TABLE | 外部数据 | +8 −0 | | LIKE source_table [ like_option ... ] } |
COPY | 查询与数据操作 | +1 −0 | REJECT_LIMIT maxerror |
DELETE | 查询与数据操作 | +1 −0 | [ RETURNING [ WITH ( { OLD | NEW } AS output_alias [, ...] ) ] |
INSERT | 查询与数据操作 | +1 −0 | [ RETURNING [ WITH ( { OLD | NEW } AS output_alias [, ...] ) ] |
MERGE | 查询与数据操作 | +1 −0 | [ RETURNING [ WITH ( { OLD | NEW } AS output_alias [, ...] ) ] |
UPDATE | 查询与数据操作 | +1 −0 | [ RETURNING [ WITH ( { OLD | NEW } AS output_alias [, ...] ) ] |
ANALYZE | 维护 | +1 −0 | [ ONLY ] table_name [ * ] [ ( column_name [, ...] ) ] |
VACUUM | 维护 | +1 −0 | [ ONLY ] table_name [ * ] [ ( column_name [, ...] ) ] |
CREATE MATERIALIZED VIEWCREATE TABLE ASREINDEXCREATE INDEXCREATE STATISTICSCREATE LANGUAGECREATE COLLATIONCREATE OPERATOR CLASSALTER OPERATOR FAMILYCREATE TYPEALTER TYPECREATE DATABASEALTER DATABASECREATE TABLESPACEALTER TABLESPACECREATE POLICYCREATE ROLECREATE ACCESS METHODCREATE EXTENSIONALTER FOREIGN TABLECREATE PUBLICATIONALTER PUBLICATIONCREATE SUBSCRIPTIONALTER SUBSCRIPTIONEXPLAINCHECKPOINTCLUSTERCOMMENT