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

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

百科 / SQL 命令 / 9.2 变更

PostgreSQL 9.2 SQL 命令变更

相对 PostgreSQL 9.1 的差异；9.2 共收录 150 条 SQL 命令。

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

换一个对比基准

汇总

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

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

新增命令 0

  • 这一版没有新增命令。

移除命令 0

  • 这一版没有移除命令。

文件改名 0

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

语法变化 44

命令分组变化行数首条新增行
CREATE SEQUENCE表与视图+1 −1[ OWNED BY { table_name.column_name | NONE } ]
ALTER SEQUENCE表与视图+5 −1ALTER SEQUENCE [ IF EXISTS ] name [ INCREMENT [ BY ] increment ]
CREATE TABLE表与视图+7 −5| LIKE source_table [ like_option ... ] }
ALTER TABLE表与视图+17 −11ALTER TABLE [ IF EXISTS ] [ ONLY ] name [ * ]
CREATE TABLE AS表与视图+1 −1[ TABLESPACE tablespace_name ]
CREATE VIEW表与视图+1 −0[ WITH ( view_option_name [= view_option_value] [, ... ] ) ]
ALTER VIEW表与视图+7 −2ALTER VIEW [ IF EXISTS ] name ALTER [ COLUMN ] column_name SET DEFAULT expression
CREATE INDEX索引与统计+3 −3CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ name ] ON table_name [ USING method ]
ALTER INDEX索引与统计+4 −0ALTER INDEX [ IF EXISTS ] name RENAME TO new_name
DROP INDEX索引与统计+1 −0DROP INDEX [ CONCURRENTLY ] [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
ALTER AGGREGATE函数与过程+3 −3ALTER AGGREGATE name ( argtype [ , ... ] ) RENAME TO new_name
DROP AGGREGATE函数与过程+1 −1DROP AGGREGATE [ IF EXISTS ] name ( argtype [ , ... ] ) [ CASCADE | RESTRICT ]
CREATE FUNCTION函数与过程+1 −0| IMMUTABLE | STABLE | VOLATILE | [ NOT ] LEAKPROOF
ALTER FUNCTION函数与过程+1 −0IMMUTABLE | STABLE | VOLATILE | [ NOT ] LEAKPROOF
ALTER DOMAIN类型与运算符+8 −0ADD domain_constraint [ NOT VALID ]
CREATE TYPE类型与运算符+7 −0( [ 'label' [, ... ] ] )
CREATE DATABASE数据库、模式与表空间+1 −1[ TABLESPACE [=] tablespace_name ]
DROP TABLESPACE数据库、模式与表空间+1 −1DROP TABLESPACE [ IF EXISTS ] name
GRANT角色与权限+10 −2GRANT { { SELECT | INSERT | UPDATE | REFERENCES } ( column_name [, ...] )
REVOKE角色与权限+14 −2{ { SELECT | INSERT | UPDATE | REFERENCES } ( column_name [, ...] )
ALTER DEFAULT PRIVILEGES角色与权限+8 −0TO { [ GROUP ] role_name | PUBLIC } [, ...] [ WITH GRANT OPTION ]
SECURITY LABEL角色与权限+5 −0AGGREGATE agg_name (agg_type [, ...] ) |
ALTER USER角色与权限+4 −0ALTER USER name [ IN DATABASE database_name ] SET configuration_parameter { TO | = } { value | DEFAULT }
CREATE RULE触发器与规则+1 −1TO table_name [ WHERE condition ]
DROP RULE触发器与规则+1 −1DROP RULE [ IF EXISTS ] name ON table_name [ CASCADE | RESTRICT ]
CREATE TRIGGER触发器与规则+1 −1ON table_name
ALTER TRIGGER触发器与规则+1 −1ALTER TRIGGER name ON table_name RENAME TO new_name
DROP TRIGGER触发器与规则+1 −1DROP TRIGGER [ IF EXISTS ] name ON table_name [ CASCADE | RESTRICT ]
ALTER EXTENSION扩展与访问方法+4 −4ALTER EXTENSION name UPDATE [ TO new_version ]
DROP EXTENSION扩展与访问方法+1 −1DROP EXTENSION [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
ALTER FOREIGN DATA WRAPPER外部数据+1 −0ALTER FOREIGN DATA WRAPPER name RENAME TO new_name
CREATE FOREIGN TABLE外部数据+1 −0{ column_name data_type [ OPTIONS ( option 'value' [, ... ] ) ] [ NULL | NOT NULL ] }
ALTER FOREIGN TABLE外部数据+13 −5ALTER FOREIGN TABLE [ IF EXISTS ] name
ALTER SERVER外部数据+3 −2ALTER SERVER name [ VERSION 'new_version' ]
DROP SERVER外部数据+1 −1DROP SERVER [ IF EXISTS ] name [ CASCADE | RESTRICT ]
COPY查询与数据操作+4 −4COPY table_name [ ( column_name [, ...] ) ]
DELETE查询与数据操作+1 −1DELETE FROM [ ONLY ] table_name [ * ] [ [ AS ] alias ]
EXPLAIN查询与数据操作+1 −0TIMING [ boolean ]
INSERT查询与数据操作+1 −1INSERT INTO table_name [ ( column_name [, ...] ) ]
SELECT查询与数据操作+1 −0with_query_name [ ( column_name [, ...] ) ] AS ( select | values | insert | update | delete )
UPDATE查询与数据操作+3 −3UPDATE [ ONLY ] table_name [ * ] [ [ AS ] alias ]
SET TRANSACTION事务控制+1 −0SET TRANSACTION SNAPSHOT snapshot_id
ANALYZE维护+1 −1ANALYZE [ VERBOSE ] [ table_name [ ( column_name [, ...] ) ] ]
VACUUM维护+3 −3VACUUM [ ( { FULL | FREEZE | VERBOSE | ANALYZE } [, ...] ) ] [ table_name [ (column_name [, ...] ) ] ]

仅正文更新 18

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

DROP TABLECREATE AGGREGATECREATE LANGUAGECREATE CASTCREATE DOMAINCREATE OPERATORCREATE OPERATOR CLASSALTER OPERATOR FAMILYALTER TYPECREATE ROLEPREPARECOMMIT PREPAREDROLLBACK PREPAREDPREPARE TRANSACTIONSETSHOWCHECKPOINTCOMMENT