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

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

百科 / SQL 命令 / 9.0 变更

PostgreSQL 9.0 SQL 命令变更

相对 PostgreSQL 8.4 的差异；9.0 共收录 141 条 SQL 命令。

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

换一个对比基准

汇总

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

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

新增命令 3

移除命令 0

  • 这一版没有移除命令。

文件改名 0

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

语法变化 69

命令分组变化行数首条新增行
CREATE TABLE表与视图+15 −7| LIKE parent_table [ like_option ... ] }
ALTER TABLE表与视图+5 −1DROP [ COLUMN ] [ IF EXISTS ] column [ RESTRICT | CASCADE ]
CREATE INDEX索引与统计+1 −0CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ name ] ON table [ USING method ]
CREATE AGGREGATE函数与过程+0 −1—
CREATE FUNCTION函数与过程+3 −3name ( [ [ argmode ] [ argname ] argtype [ { DEFAULT | = } default_expr ] [, ...] ] )
ALTER FUNCTION函数与过程+0 −1—
CREATE LANGUAGE函数与过程+3 −0CREATE [ OR REPLACE ] [ PROCEDURAL ] LANGUAGE name
ALTER LANGUAGE函数与过程+1 −1ALTER [ PROCEDURAL ] LANGUAGE name RENAME TO new_name
CREATE CAST类型与运算符+4 −4CREATE CAST (source_type AS target_type)
DROP CAST类型与运算符+1 −1DROP CAST [ IF EXISTS ] (source_type AS target_type) [ CASCADE | RESTRICT ]
CREATE CONVERSION类型与运算符+1 −1FOR source_encoding TO dest_encoding FROM function_name
ALTER CONVERSION类型与运算符+2 −2ALTER CONVERSION name RENAME TO new_name
CREATE DOMAIN类型与运算符+0 −1—
CREATE OPERATOR类型与运算符+2 −2PROCEDURE = function_name
ALTER OPERATOR类型与运算符+1 −1ALTER OPERATOR name ( { left_type | NONE } , { right_type | NONE } ) OWNER TO new_owner
DROP OPERATOR类型与运算符+1 −1DROP OPERATOR [ IF EXISTS ] name ( { left_type | NONE } , { right_type | NONE } ) [ CASCADE | RESTRICT ]
CREATE OPERATOR CLASS类型与运算符+1 −1| FUNCTION support_number [ ( op_type [ , op_type ] ) ] function_name ( argument_type [, ...] )
ALTER OPERATOR CLASS类型与运算符+2 −2ALTER OPERATOR CLASS name USING index_method RENAME TO new_name
ALTER OPERATOR FAMILY类型与运算符+3 −3| FUNCTION support_number [ ( op_type [ , op_type ] ) ] function_name ( argument_type [, ...] )
CREATE TYPE类型与运算符+1 −0( [ 'label' [, ... ] ] )
CREATE DATABASE数据库、模式与表空间+1 −1[ [ WITH ] [ OWNER [=] user_name ]
ALTER DATABASE数据库、模式与表空间+1 −2ALTER DATABASE name RENAME TO new_name
CREATE SCHEMA数据库、模式与表空间+2 −2CREATE SCHEMA schema_name [ AUTHORIZATION user_name ] [ schema_element [ ... ] ]
ALTER SCHEMA数据库、模式与表空间+2 −2ALTER SCHEMA name RENAME TO new_name
CREATE TABLESPACE数据库、模式与表空间+1 −1CREATE TABLESPACE tablespace_name [ OWNER user_name ] LOCATION 'directory'
ALTER TABLESPACE数据库、模式与表空间+4 −2ALTER TABLESPACE name RENAME TO new_name
DROP TABLESPACE数据库、模式与表空间+1 −1DROP TABLESPACE [ IF EXISTS ] tablespace_name
GRANT角色与权限+27 −21ON { [ TABLE ] table_name [, ...]
REVOKE角色与权限+29 −21ON { [ TABLE ] table_name [, ...]
CREATE GROUP角色与权限+5 −6| IN ROLE role_name [, ...]
ALTER GROUP角色与权限+3 −3ALTER GROUP group_name ADD USER user_name [, ... ]
CREATE ROLE角色与权限+5 −6| IN ROLE role_name [, ...]
ALTER ROLE角色与权限+5 −2ALTER ROLE name RENAME TO new_name
SET ROLE角色与权限+1 −1SET [ SESSION | LOCAL ] ROLE role_name
SET SESSION AUTHORIZATION角色与权限+1 −1SET [ SESSION | LOCAL ] SESSION AUTHORIZATION user_name
CREATE USER角色与权限+5 −6| IN ROLE role_name [, ...]
ALTER USER角色与权限+1 −2ALTER USER name RENAME TO new_name
CREATE CONSTRAINT TRIGGER触发器与规则+2 −1[ WHEN ( condition ) ]
DROP RULE触发器与规则+1 −1DROP RULE [ IF EXISTS ] name ON table [ CASCADE | RESTRICT ]
CREATE TRIGGER触发器与规则+2 −1[ WHEN ( condition ) ]
ALTER TRIGGER触发器与规则+1 −1ALTER TRIGGER name ON table RENAME TO new_name
ALTER TEXT SEARCH CONFIGURATION全文检索+2 −2ALTER TEXT SEARCH CONFIGURATION name RENAME TO new_name
ALTER TEXT SEARCH DICTIONARY全文检索+2 −2ALTER TEXT SEARCH DICTIONARY name RENAME TO new_name
ALTER TEXT SEARCH PARSER全文检索+1 −1ALTER TEXT SEARCH PARSER name RENAME TO new_name
ALTER TEXT SEARCH TEMPLATE全文检索+1 −1ALTER TEXT SEARCH TEMPLATE name RENAME TO new_name
CREATE SERVER外部数据+2 −2CREATE SERVER server_name [ TYPE 'server_type' ] [ VERSION 'server_version' ]
ALTER SERVER外部数据+2 −2ALTER SERVER server_name [ VERSION 'new_version' ]
DROP SERVER外部数据+1 −1DROP SERVER [ IF EXISTS ] server_name [ CASCADE | RESTRICT ]
CREATE USER MAPPING外部数据+2 −2CREATE USER MAPPING FOR { user_name | USER | CURRENT_USER | PUBLIC }
ALTER USER MAPPING外部数据+2 −2ALTER USER MAPPING FOR { user_name | USER | CURRENT_USER | PUBLIC }
DROP USER MAPPING外部数据+1 −1DROP USER MAPPING [ IF EXISTS ] FOR { user_name | USER | CURRENT_USER | PUBLIC } SERVER server_name
COPY查询与数据操作+13 −18COPY table_name [ ( column [, ...] ) ]
DELETE查询与数据操作+1 −1[ USING using_list ]
EXPLAIN查询与数据操作+6 −0EXPLAIN [ ( option [, ...] ) ] statement
LOCK查询与数据操作+0 −1—
SELECT查询与数据操作+0 −2—
UPDATE查询与数据操作+1 −1[ FROM from_list ]
FETCH游标与预备语句+1 −2FETCH [ direction [ FROM | IN ] ] cursor_name
MOVE游标与预备语句+1 −1MOVE [ direction [ FROM | IN ] ] cursor_name
PREPARE游标与预备语句+1 −1PREPARE name [ ( data_type [, ...] ) ] AS statement
BEGIN事务控制+0 −1—
SET TRANSACTION事务控制+0 −1—
START TRANSACTION事务控制+0 −1—
LISTEN会话与参数+1 −1LISTEN channel
NOTIFY会话与参数+1 −1NOTIFY channel [ , payload ]
UNLISTEN会话与参数+1 −1UNLISTEN { channel | * }
CLUSTER维护+1 −1CLUSTER [VERBOSE] table_name [ USING index_name ]
VACUUM维护+1 −0VACUUM [ ( { FULL | FREEZE | VERBOSE | ANALYZE } [, ...] ) ] [ table [ (column [, ...] ) ] ]
COMMENT其它对象+4 −5CAST (source_type AS target_type) |

仅正文更新 18

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

TRUNCATECREATE SEQUENCECREATE VIEWREINDEXDROP CONVERSIONCREATE OPERATOR FAMILYREASSIGN OWNEDCREATE RULELOADSELECT INTODECLARESAVEPOINTSET CONSTRAINTSROLLBACK TO SAVEPOINTPREPARE TRANSACTIONSHOWANALYZECHECKPOINT