pgsql.cc 提供对 postgresql.org 官网内容的中文翻译，由 Pigsty 团队维护。
相对 PostgreSQL 9.5 的差异；9.6 共收录 167 条 SQL 命令。
PostgreSQL 9.6 为历史版本，已结束维护。
语法变化按参考页「语法概要」逐行比较；文件改名独立统计，可能同时有语法或正文变化。
CREATE ACCESS METHOD扩展与访问方法
定义一种新的访问方法
DROP ACCESS METHOD扩展与访问方法
移除一个访问方法
| 命令 | 分组 | 变化行数 | 首条新增行 |
|---|---|---|---|
ALTER MATERIALIZED VIEW | 表与视图 | +2 −0 | ALTER MATERIALIZED VIEW name |
ALTER TABLE | 表与视图 | +1 −0 | ADD [ COLUMN ] [ IF NOT EXISTS ] column_name data_type [ COLLATE collation ] [ column_constraint [ ... ] ] |
ALTER INDEX | 索引与统计 | +1 −0 | ALTER INDEX name DEPENDS ON EXTENSION extension_name |
CREATE AGGREGATE | 函数与过程 | +12 −0 | [ , FINALFUNC_EXTRA ] |
CREATE FUNCTION | 函数与过程 | +4 −0 | | { IMMUTABLE | STABLE | VOLATILE } |
ALTER FUNCTION | 函数与过程 | +3 −1 | ALTER FUNCTION name ( [ [ argmode ] [ argname ] argtype [, ...] ] ) |
DROP TRANSFORM | 函数与过程 | +1 −0 | DROP TRANSFORM [ IF EXISTS ] FOR type_name LANGUAGE lang_name [ CASCADE | RESTRICT ] |
ALTER OPERATOR | 类型与运算符 | +4 −0 | ALTER OPERATOR name ( { left_type | NONE } , { right_type | NONE } ) |
CREATE GROUP | 角色与权限 | +0 −1 | — |
DROP POLICY | 角色与权限 | +1 −0 | DROP POLICY [ IF EXISTS ] name ON table_name [ CASCADE | RESTRICT ] |
CREATE ROLE | 角色与权限 | +0 −1 | — |
ALTER ROLE | 角色与权限 | +0 −1 | — |
CREATE USER | 角色与权限 | +0 −1 | — |
ALTER USER | 角色与权限 | +0 −1 | — |
ALTER TRIGGER | 触发器与规则 | +1 −0 | ALTER TRIGGER name ON table_name DEPENDS ON EXTENSION extension_name |
CREATE EXTENSION | 扩展与访问方法 | +1 −0 | [ CASCADE ] |
ALTER EXTENSION | 扩展与访问方法 | +1 −0 | ACCESS METHOD object_name | |
VACUUM | 维护 | +1 −0 | VACUUM [ ( { FULL | FREEZE | VERBOSE | ANALYZE | DISABLE_PAGE_SKIPPING } [, ...] ) ] [ table_name [ (column_name [, ...] ) ] ] |
COMMENT | 其它对象 | +1 −0 | ACCESS METHOD object_name | |
DROP MATERIALIZED VIEWCREATE SEQUENCEDROP SEQUENCECREATE TABLEDROP TABLECREATE VIEWDROP VIEWREINDEXCREATE INDEXDROP INDEXDROP AGGREGATEDROP FUNCTIONCREATE LANGUAGEDROP LANGUAGECREATE COLLATIONDROP COLLATIONALTER DOMAINDROP DOMAINCREATE OPERATORDROP OPERATORCREATE OPERATOR CLASSDROP OPERATOR CLASSCREATE OPERATOR FAMILYALTER OPERATOR FAMILYDROP OPERATOR FAMILYCREATE TYPEDROP TYPECREATE DATABASEALTER DATABASECREATE SCHEMADROP SCHEMACREATE TABLESPACEALTER TABLESPACEGRANTREVOKEDROP OWNEDREASSIGN OWNEDDROP ROLESET ROLECREATE EVENT TRIGGERDROP EVENT TRIGGERCREATE RULEDROP RULECREATE TRIGGERDROP TRIGGERLOADDROP EXTENSIONDROP TEXT SEARCH CONFIGURATIONDROP TEXT SEARCH DICTIONARYDROP TEXT SEARCH PARSERDROP TEXT SEARCH TEMPLATEDROP FOREIGN DATA WRAPPERALTER FOREIGN TABLEDROP FOREIGN TABLEDROP SERVERCREATE USER MAPPINGALTER USER MAPPINGDROP USER MAPPINGCOPYSELECTSELECT INTODECLAREFETCHPREPAREPREPARE TRANSACTIONSET TRANSACTIONNOTIFYRESETSETSHOWALTER SYSTEMANALYZECHECKPOINTALTER LARGE OBJECT