pgsql.cc 提供对 postgresql.org 官网内容的中文翻译，由 Pigsty 团队维护。
相对 PostgreSQL 16 的差异；17 共收录 183 条 SQL 命令。
语法变化按参考页「语法概要」逐行比较；文件改名独立统计，可能同时有语法或正文变化。
| 命令 | 分组 | 变化行数 | 首条新增行 |
|---|---|---|---|
ALTER TABLE | 表与视图 | +4 −0 | ALTER [ COLUMN ] column_name SET EXPRESSION AS ( expression ) |
ALTER STATISTICS | 索引与统计 | +1 −0 | ALTER STATISTICS name SET STATISTICS { new_target | DEFAULT } |
CREATE DOMAIN | 类型与运算符 | +1 −1 | [ domain_constraint [ ... ] ] |
ALTER OPERATOR | 类型与运算符 | +4 −0 | | COMMUTATOR = com_op |
CREATE DATABASE | 数据库、模式与表空间 | +2 −0 | [ LC_CTYPE [=] lc_ctype ] |
GRANT | 角色与权限 | +1 −0 | GRANT { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER | MAINTAIN } |
REVOKE | 角色与权限 | +1 −0 | { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER | MAINTAIN } |
ALTER DEFAULT PRIVILEGES | 角色与权限 | +2 −0 | GRANT { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER | MAINTAIN } |
CREATE ROLE | 角色与权限 | +0 −4 | — |
COPY | 查询与数据操作 | +4 −0 | FORCE_NOT_NULL { ( column_name [, ...] ) | * } |
EXPLAIN | 查询与数据操作 | +3 −2 | SERIALIZE [ { NONE | TEXT | BINARY } ] |
MERGE | 查询与数据操作 | +4 −0 | when_clause [...] |
SELECT | 查询与数据操作 | +2 −1 | [ FOR { UPDATE | NO KEY UPDATE | SHARE | KEY SHARE } [ OF from_reference [, ...] ] [ NOWAIT | SKIP LOCKED ] [...] ] |
ANALYZE | 维护 | +0 −2 | — |
CLUSTER | 维护 | +1 −3 | CLUSTER [ ( option [, ...] ) ] [ table_name [ USING index_name ] ] |
VACUUM | 维护 | +0 −2 | — |
CREATE MATERIALIZED VIEWDROP MATERIALIZED VIEWREFRESH MATERIALIZED VIEWDROP SEQUENCECREATE TABLEDROP TABLECREATE TABLE ASCREATE VIEWDROP VIEWREINDEXCREATE INDEXDROP INDEXCREATE STATISTICSCALLCREATE AGGREGATEDROP AGGREGATECREATE FUNCTIONALTER FUNCTIONDROP FUNCTIONCREATE LANGUAGEDROP LANGUAGECREATE PROCEDUREALTER PROCEDUREDROP PROCEDUREDROP TRANSFORMCREATE COLLATIONDROP COLLATIONALTER DOMAINDROP DOMAINCREATE OPERATORDROP OPERATORCREATE OPERATOR CLASSDROP OPERATOR CLASSCREATE OPERATOR FAMILYALTER OPERATOR FAMILYDROP OPERATOR FAMILYCREATE TYPEALTER TYPEDROP TYPEALTER DATABASEDROP DATABASEDROP SCHEMACREATE TABLESPACEDROP OWNEDREASSIGN OWNEDCREATE POLICYALTER ROLEDROP ROLESET ROLESET SESSION AUTHORIZATIONCREATE EVENT TRIGGERDROP EVENT TRIGGERCREATE RULEDROP RULECREATE TRIGGERDROP TRIGGERLOADCREATE ACCESS METHODDROP ACCESS METHODCREATE EXTENSIONALTER EXTENSIONDROP EXTENSIONDROP TEXT SEARCH CONFIGURATIONDROP TEXT SEARCH DICTIONARYDROP TEXT SEARCH PARSERDROP TEXT SEARCH TEMPLATEDROP FOREIGN DATA WRAPPERALTER FOREIGN TABLEDROP FOREIGN TABLEDROP SERVERCREATE PUBLICATIONCREATE SUBSCRIPTIONALTER SUBSCRIPTIONDROP SUBSCRIPTIONDELETEINSERTLOCKUPDATESELECT INTODECLAREFETCHRELEASE SAVEPOINTPREPARE TRANSACTIONSET TRANSACTIONLISTENNOTIFYRESETSETSHOWALTER SYSTEMCHECKPOINTCOMMENTALTER LARGE OBJECT