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

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

百科 / SQL 命令 / 8.2 变更

PostgreSQL 8.2 SQL 命令变更

相对 PostgreSQL 8.1 的差异；8.2 共收录 112 条 SQL 命令。

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

换一个对比基准

汇总

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

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

新增命令 3

  • DROP OWNED角色与权限

    移除一个数据库角色所拥有的数据库对象

  • REASSIGN OWNED角色与权限

    更改一个数据库角色所拥有的数据库对象的所有权

  • VALUES查询与数据操作

    计算一组行

移除命令 0

  • 这一版没有移除命令。

文件改名 0

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

语法变化 50

命令分组变化行数首条新增行
TRUNCATE表与视图+1 −0TRUNCATE [ TABLE ] name [, ...] [ CASCADE | RESTRICT ]
CREATE SEQUENCE表与视图+1 −0[ OWNED BY { table.column | NONE } ]
ALTER SEQUENCE表与视图+1 −0[ OWNED BY { table.column | NONE } ]
DROP SEQUENCE表与视图+1 −0DROP SEQUENCE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
CREATE TABLE表与视图+9 −4| LIKE parent_table [ { INCLUDING | EXCLUDING } { DEFAULTS | CONSTRAINTS } ] ... }
ALTER TABLE表与视图+4 −0SET ( storage_parameter = value [, ... ] )
DROP TABLE表与视图+1 −0DROP TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
CREATE TABLE AS表与视图+3 −1[ WITH ( storage_parameter [= value] [, ... ] ) | WITH OIDS | WITHOUT OIDS ]
DROP VIEW表与视图+1 −0DROP VIEW [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
CREATE INDEX索引与统计+3 −0CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] name ON table [ USING method ]
ALTER INDEX索引与统计+2 −0ALTER INDEX name SET ( storage_parameter = value [, ... ] )
DROP INDEX索引与统计+1 −0DROP INDEX [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
CREATE AGGREGATE函数与过程+9 −1CREATE AGGREGATE name ( input_data_type [ , ... ] ) (
ALTER AGGREGATE函数与过程+3 −0ALTER AGGREGATE name ( type [ , ... ] ) RENAME TO new_name
DROP AGGREGATE函数与过程+1 −0DROP AGGREGATE [ IF EXISTS ] name ( type [ , ... ] ) [ CASCADE | RESTRICT ]
DROP FUNCTION函数与过程+1 −0DROP FUNCTION [ IF EXISTS ] name ( [ [ argmode ] [ argname ] argtype [, ...] ] )
DROP LANGUAGE函数与过程+1 −0DROP [ PROCEDURAL ] LANGUAGE [ IF EXISTS ] name [ CASCADE | RESTRICT ]
DROP CAST类型与运算符+1 −0DROP CAST [ IF EXISTS ] (sourcetype AS targettype) [ CASCADE | RESTRICT ]
DROP CONVERSION类型与运算符+1 −0DROP CONVERSION [ IF EXISTS ] name [ CASCADE | RESTRICT ]
DROP DOMAIN类型与运算符+1 −0DROP DOMAIN [IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
DROP OPERATOR类型与运算符+1 −0DROP OPERATOR [ IF EXISTS ] name ( { lefttype | NONE } , { righttype | NONE } ) [ CASCADE | RESTRICT ]
DROP OPERATOR CLASS类型与运算符+1 −0DROP OPERATOR CLASS [ IF EXISTS ] name USING index_method [ CASCADE | RESTRICT ]
CREATE TYPE类型与运算符+1 −0CREATE TYPE name
DROP TYPE类型与运算符+1 −0DROP TYPE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
DROP DATABASE数据库、模式与表空间+1 −0DROP DATABASE [ IF EXISTS ] name
DROP SCHEMA数据库、模式与表空间+1 −0DROP SCHEMA [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
DROP TABLESPACE数据库、模式与表空间+1 −0DROP TABLESPACE [ IF EXISTS ] tablespacename
GRANT角色与权限+5 −1GRANT { { USAGE | SELECT | UPDATE }
REVOKE角色与权限+7 −1{ { USAGE | SELECT | UPDATE }
DROP GROUP角色与权限+1 −0DROP GROUP [ IF EXISTS ] name [, ...]
ALTER ROLE角色与权限+2 −2ALTER ROLE name SET configuration_parameter { TO | = } { value | DEFAULT }
DROP ROLE角色与权限+1 −0DROP ROLE [ IF EXISTS ] name [, ...]
ALTER USER角色与权限+2 −2ALTER USER name SET configuration_parameter { TO | = } { value | DEFAULT }
DROP USER角色与权限+1 −0DROP USER [ IF EXISTS ] name [, ...]
CREATE CONSTRAINT TRIGGER触发器与规则+5 −3AFTER event [ OR ... ]
DROP RULE触发器与规则+1 −0DROP RULE [ IF EXISTS ] name ON relation [ CASCADE | RESTRICT ]
DROP TRIGGER触发器与规则+1 −0DROP TRIGGER [ IF EXISTS ] name ON table [ CASCADE | RESTRICT ]
COPY查询与数据操作+1 −0COPY { tablename [ ( column [, ...] ) ] | ( query ) }
DELETE查询与数据操作+2 −0DELETE FROM [ ONLY ] table [ [ AS ] alias ]
INSERT查询与数据操作+2 −0{ DEFAULT VALUES | VALUES ( { expression | DEFAULT } [, ...] ) [, ...] | query }
SELECT查询与数据操作+1 −0[ FOR { UPDATE | SHARE } [ OF table_name [, ...] ] [ NOWAIT ] [...] ]
UPDATE查询与数据操作+4 −0UPDATE [ ONLY ] table [ [ AS ] alias ]
SELECT INTO查询与数据操作+1 −0[ FOR { UPDATE | SHARE } [ OF table_name [, ...] ] [ NOWAIT ] [...] ]
DEALLOCATE游标与预备语句+1 −1DEALLOCATE [ PREPARE ] name
EXECUTE游标与预备语句+1 −1EXECUTE name [ (parameter [, ...] ) ]
PREPARE游标与预备语句+1 −1PREPARE name [ (datatype [, ...] ) ] AS statement
RESET会话与参数+1 −1RESET configuration_parameter
SET会话与参数+1 −1SET [ SESSION | LOCAL ] configuration_parameter { TO | = } { value | 'value' | DEFAULT }
VACUUM维护+2 −2VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] [ table ]
COMMENT其它对象+4 −0AGGREGATE agg_name (agg_type [, ...] ) |

仅正文更新 25

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

CREATE VIEWREINDEXCREATE FUNCTIONCREATE LANGUAGECREATE DOMAINALTER DOMAINCREATE OPERATORCREATE OPERATOR CLASSCREATE DATABASEALTER DATABASECREATE TABLESPACECREATE GROUPCREATE ROLECREATE USERCREATE RULECREATE TRIGGERLOADEXPLAINCLOSEDECLAREBEGINSET CONSTRAINTSSHOWCHECKPOINTCLUSTER