pgsql.cc 提供对 postgresql.org 官网内容的中文翻译，由 Pigsty 团队维护。
相对 PostgreSQL 9.0 的差异；9.1 共收录 150 条 SQL 命令。
PostgreSQL 9.1 为历史版本，已结束维护。
语法变化按参考页「语法概要」逐行比较；文件改名独立统计，可能同时有语法或正文变化。
CREATE COLLATION类型与运算符
定义一种新排序规则
ALTER COLLATION类型与运算符
更改排序规则的定义
DROP COLLATION类型与运算符
删除一个排序规则
SECURITY LABEL角色与权限
定义或更改应用于对象的安全标签
CREATE EXTENSION扩展与访问方法
安装一个扩展
ALTER EXTENSION扩展与访问方法
更改扩展的定义
DROP EXTENSION扩展与访问方法
移除一个扩展
定义一个新外部表
更改外部表的定义
移除一个外部表
CREATE CONSTRAINT TRIGGER触发器与规则
定义一个新的约束触发器
| 命令 | 分组 | 变化行数 | 首条新增行 |
|---|---|---|---|
CREATE TABLE | 表与视图 | +5 −2 | CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXISTS ] table_name ( [ |
ALTER TABLE | 表与视图 | +10 −2 | ADD [ COLUMN ] column data_type [ COLLATE collation ] [ column_constraint [ ... ] ] |
CREATE TABLE AS | 表与视图 | +1 −0 | CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE table_name |
CREATE INDEX | 索引与统计 | +1 −0 | ( { column | ( expression ) } [ COLLATE collation ] [ opclass ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ] [, ...] ) |
ALTER CONVERSION | 类型与运算符 | +1 −0 | ALTER CONVERSION name SET SCHEMA new_schema |
CREATE DOMAIN | 类型与运算符 | +1 −0 | [ COLLATE collation ] |
ALTER OPERATOR | 类型与运算符 | +1 −0 | ALTER OPERATOR name ( { left_type | NONE } , { right_type | NONE } ) SET SCHEMA new_schema |
CREATE OPERATOR CLASS | 类型与运算符 | +1 −0 | { OPERATOR strategy_number operator_name [ ( op_type, op_type ) ] [ FOR SEARCH | FOR ORDER BY sort_family_name ] |
ALTER OPERATOR CLASS | 类型与运算符 | +1 −0 | ALTER OPERATOR CLASS name USING index_method SET SCHEMA new_schema |
ALTER OPERATOR FAMILY | 类型与运算符 | +2 −0 | { OPERATOR strategy_number operator_name ( op_type, op_type ) [ FOR SEARCH | FOR ORDER BY sort_family_name ] |
CREATE TYPE | 类型与运算符 | +2 −0 | ( [ attribute_name data_type [ COLLATE collation ] [, ... ] ] ) |
ALTER TYPE | 类型与运算符 | +8 −2 | ALTER TYPE name action [, ... ] |
CREATE ROLE | 角色与权限 | +1 −0 | | REPLICATION | NOREPLICATION |
ALTER ROLE | 角色与权限 | +1 −0 | | REPLICATION | NOREPLICATION |
CREATE USER | 角色与权限 | +1 −0 | | REPLICATION | NOREPLICATION |
ALTER USER | 角色与权限 | +1 −0 | | REPLICATION | NOREPLICATION |
CREATE TRIGGER | 触发器与规则 | +7 −0 | CREATE [ CONSTRAINT ] TRIGGER name { BEFORE | AFTER | INSTEAD OF } { event [ OR ... ] } |
ALTER TEXT SEARCH CONFIGURATION | 全文检索 | +1 −0 | ALTER TEXT SEARCH CONFIGURATION name SET SCHEMA new_schema |
ALTER TEXT SEARCH DICTIONARY | 全文检索 | +1 −0 | ALTER TEXT SEARCH DICTIONARY name SET SCHEMA new_schema |
ALTER TEXT SEARCH PARSER | 全文检索 | +1 −0 | ALTER TEXT SEARCH PARSER name SET SCHEMA new_schema |
ALTER TEXT SEARCH TEMPLATE | 全文检索 | +1 −0 | ALTER TEXT SEARCH TEMPLATE name SET SCHEMA new_schema |
CREATE FOREIGN DATA WRAPPER | 外部数据 | +2 −1 | [ HANDLER handler_function | NO HANDLER ] |
ALTER FOREIGN DATA WRAPPER | 外部数据 | +2 −1 | [ HANDLER handler_function | NO HANDLER ] |
COPY | 查询与数据操作 | +1 −0 | ENCODING 'encoding_name' |
DELETE | 查询与数据操作 | +1 −0 | [ WITH [ RECURSIVE ] with_query [, ...] ] |
INSERT | 查询与数据操作 | +1 −0 | [ WITH [ RECURSIVE ] with_query [, ...] ] |
SELECT | 查询与数据操作 | +2 −1 | [ { UNION | INTERSECT | EXCEPT } [ ALL | DISTINCT ] select ] |
UPDATE | 查询与数据操作 | +1 −0 | [ WITH [ RECURSIVE ] with_query [, ...] ] |
SELECT INTO | 查询与数据操作 | +2 −0 | INTO [ TEMPORARY | TEMP | UNLOGGED ] [ TABLE ] new_table |
MOVE | 游标与预备语句 | +14 −0 | NEXT |
BEGIN | 事务控制 | +1 −0 | [ NOT ] DEFERRABLE |
SET TRANSACTION | 事务控制 | +1 −0 | [ NOT ] DEFERRABLE |
START TRANSACTION | 事务控制 | +1 −0 | [ NOT ] DEFERRABLE |
COMMENT | 其它对象 | +7 −1 | COLLATION object_name | |