↑↓ 选择 ↵ 打开 ⌫ 改范围 完整检索页

pgsql.cc 提供对 postgresql.org 官网内容的中文翻译，由 Pigsty 团队维护。

百科 / SQL 命令 / 12 变更

PostgreSQL 12 SQL 命令变更

相对 PostgreSQL 11 的差异；12 共收录 182 条 SQL 命令。

PostgreSQL 12 为历史版本，已结束维护。

换一个对比基准

汇总

  1. 0新增命令
  2. 0移除命令
  3. 0文件改名
  4. 27语法变化
  5. 69仅正文更新

语法变化按参考页「语法概要」逐行比较；文件改名独立统计，可能同时有语法或正文变化。

新增命令 0

  • 这一版没有新增命令。

移除命令 0

  • 这一版没有移除命令。

文件改名 0

  • 这一版没有参考页改名。

语法变化 27

命令分组变化行数首条新增行
CREATE MATERIALIZED VIEW表与视图+2 −0[ (column_name [, ...] ) ]
CREATE TABLE表与视图+14 −8[ USING method ]
ALTER TABLE表与视图+7 −7IN ( partition_bound_expr [, ...] ) |
CREATE TABLE AS表与视图+2 −1[ USING method ]
REINDEX索引与统计+1 −0REINDEX [ ( VERBOSE ) ] { INDEX | TABLE | SCHEMA | DATABASE | SYSTEM } [ CONCURRENTLY ] name
CREATE AGGREGATE函数与过程+3 −0CREATE [ OR REPLACE ] AGGREGATE name ( [ argmode ] [ argname ] arg_data_type [ , ... ] ) (
CREATE FUNCTION函数与过程+2 −0| SUPPORT support_function
ALTER FUNCTION函数与过程+1 −0SUPPORT support_function
CREATE COLLATION类型与运算符+2 −0[ DETERMINISTIC = boolean, ]
ALTER DOMAIN类型与运算符+2 −0[ CONSTRAINT constraint_name ]
ALTER DEFAULT PRIVILEGES角色与权限+4 −0GRANT { { USAGE | CREATE }
SECURITY LABEL角色与权限+1 −0FOREIGN TABLE object_name |
CREATE FOREIGN TABLE外部数据+5 −3DEFAULT default_expr |
ALTER FOREIGN TABLE外部数据+0 −2—
COPY查询与数据操作+2 −1[ [ WITH ] ( option [, ...] ) ]
DELETE查询与数据操作+1 −0[ RETURNING { * | output_expression [ [ AS ] output_name ] } [, ...] ]
EXPLAIN查询与数据操作+1 −0SETTINGS [ boolean ]
INSERT查询与数据操作+1 −0[ RETURNING { * | output_expression [ [ AS ] output_name ] } [, ...] ]
SELECT查询与数据操作+2 −0[ { * | expression [ [ AS ] output_name ] } [, ...] ]
UPDATE查询与数据操作+1 −0[ RETURNING { * | output_expression [ [ AS ] output_name ] } [, ...] ]
SELECT INTO查询与数据操作+1 −0[ { * | expression [ [ AS ] output_name ] } [, ...] ]
ABORT事务控制+1 −0ABORT [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ]
COMMIT事务控制+1 −0COMMIT [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ]
END事务控制+1 −0END [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ]
ROLLBACK事务控制+1 −0ROLLBACK [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ]
ANALYZE维护+2 −0VERBOSE [ boolean ]
VACUUM维护+8 −0FULL [ boolean ]

仅正文更新 69

69 条命令的语法未变，说明文字有更新

TRUNCATEALTER MATERIALIZED VIEWDROP MATERIALIZED VIEWDROP SEQUENCEDROP TABLECREATE VIEWDROP VIEWCREATE INDEXALTER INDEXDROP INDEXCREATE STATISTICSCALLDROP AGGREGATEDROP FUNCTIONCREATE LANGUAGEDROP LANGUAGECREATE PROCEDUREDROP PROCEDUREDROP TRANSFORMDROP COLLATIONCREATE DOMAINDROP DOMAINCREATE OPERATORDROP OPERATORCREATE OPERATOR CLASSDROP OPERATOR CLASSCREATE OPERATOR FAMILYALTER OPERATOR FAMILYDROP OPERATOR FAMILYCREATE TYPEALTER TYPEDROP TYPEDROP SCHEMACREATE TABLESPACEGRANTREVOKEDROP OWNEDCREATE POLICYCREATE EVENT TRIGGERALTER 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 TEMPLATEALTER FOREIGN DATA WRAPPERDROP FOREIGN DATA WRAPPERDROP FOREIGN TABLEDROP SERVERCREATE PUBLICATIONCREATE SUBSCRIPTIONDROP SUBSCRIPTIONDECLAREFETCHPREPARESETCHECKPOINTCOMMENTALTER LARGE OBJECT