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

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

百科 / SQL 命令 / 7.2 变更

PostgreSQL 7.2 SQL 命令变更

相对 PostgreSQL 7.1 的差异；7.2 共收录 69 条 SQL 命令。

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

换一个对比基准

汇总

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

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

新增命令 2

移除命令 0

  • 这一版没有移除命令。

文件改名 0

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

语法变化 25

命令分组变化行数首条新增行
CREATE SEQUENCE表与视图+1 −0CREATE [ TEMPORARY | TEMP ] SEQUENCE seqname [ INCREMENT increment ]
CREATE TABLE表与视图+11 −9CREATE [ [ LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name (
ALTER TABLE表与视图+9 −3ADD [ COLUMN ] column type [ column_constraint [ ... ] ]
CREATE TABLE AS表与视图+2 −2CREATE [ [ LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name [ (column_name [, ...] ) ]
CREATE VIEW表与视图+1 −0CREATE VIEW view [ ( column name list ) ] AS SELECT query
CREATE INDEX索引与统计+4 −2[ USING acc_method ] ( column [ ops_name ] [, ...] )
DROP AGGREGATE函数与过程+1 −0DROP AGGREGATE name ( type )
CREATE FUNCTION函数与过程+8 −8CREATE [ OR REPLACE ] FUNCTION name ( [ argtype [, ...] ] )
CREATE LANGUAGE函数与过程+1 −2CREATE [ TRUSTED ] [ PROCEDURAL ] LANGUAGE langname
DROP LANGUAGE函数与过程+1 −1DROP [ PROCEDURAL ] LANGUAGE name
CREATE OPERATOR类型与运算符+2 −1[, LEFTARG = lefttype
CREATE TYPE类型与运算符+1 −1[ , DEFAULT = default ]
GRANT角色与权限+3 −2GRANT { { SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES | TRIGGER } [,...] | ALL [ PRIVILEGES ] }
REVOKE角色与权限+3 −2REVOKE { { SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES | TRIGGER } [,...] | ALL [ PRIVILEGES ] }
CREATE GROUP角色与权限+3 −2CREATE GROUP name [ [ WITH ] option [ ... ] ]
CREATE USER角色与权限+7 −4CREATE USER username [ [ WITH ] option [ ... ] ]
ALTER USER角色与权限+6 −3ALTER USER username [ [ WITH ] option [ ... ] ]
EXPLAIN查询与数据操作+1 −0EXPLAIN [ ANALYZE ] [ VERBOSE ] query
LOCK查询与数据操作+5 −2LOCK [ TABLE ] name [, ...]
SELECT查询与数据操作+2 −2[ { UNION | INTERSECT | EXCEPT } [ ALL ] select ]
SELECT INTO查询与数据操作+2 −2[ { UNION | INTERSECT | EXCEPT } [ ALL ] select ]
RESET会话与参数+1 −0RESET ALL
SHOW会话与参数+1 −0SHOW ALL
VACUUM维护+2 −1VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] [ table ]
COMMENT其它对象+1 −0AGGREGATE agg_name (agg_type) |

仅正文更新 42

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

TRUNCATEDROP SEQUENCEDROP TABLEDROP VIEWREINDEXDROP INDEXCREATE AGGREGATEDROP FUNCTIONDROP OPERATORDROP TYPECREATE DATABASEDROP DATABASEALTER GROUPDROP GROUPDROP USERCREATE CONSTRAINT TRIGGERCREATE RULEDROP RULECREATE TRIGGERDROP TRIGGERLOADCOPYDELETEINSERTUPDATECLOSEDECLAREFETCHMOVEABORTBEGINCOMMITENDROLLBACKSET CONSTRAINTSSET TRANSACTIONLISTENNOTIFYSETUNLISTENCHECKPOINTCLUSTER