pgsql.cc 提供对 postgresql.org 官网内容的中文翻译，由 Pigsty 团队维护。
相对 PostgreSQL 7.3 的差异；7.4 共收录 93 条 SQL 命令。
PostgreSQL 7.4 为历史版本，已结束维护。
语法变化按参考页「语法概要」逐行比较；文件改名独立统计，可能同时有语法或正文变化。
ALTER SEQUENCE表与视图
更改序列发生器的定义
ALTER AGGREGATE函数与过程
更改一个聚合函数的定义
ALTER FUNCTION函数与过程
更改一个函数的定义
ALTER LANGUAGE函数与过程
更改一个过程语言的定义
ALTER CONVERSION类型与运算符
更改一个转换的定义
ALTER DOMAIN类型与运算符
更改一个域的定义
ALTER OPERATOR CLASS类型与运算符
更改一个操作符类的定义
ALTER SCHEMA数据库、模式与表空间
更改一个模式的定义
| 命令 | 分组 | 变化行数 | 首条新增行 |
|---|---|---|---|
CREATE SEQUENCE | 表与视图 | +3 −1 | CREATE [ TEMPORARY | TEMP ] SEQUENCE name [ INCREMENT [ BY ] increment ] |
CREATE TABLE | 表与视图 | +6 −1 | CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name ( |
ALTER TABLE | 表与视图 | +17 −13 | ALTER TABLE [ ONLY ] name [ * ] |
CREATE TABLE AS | 表与视图 | +1 −0 | CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name [ (column_name [, ...] ) ] |
CREATE VIEW | 表与视图 | +1 −1 | CREATE [ OR REPLACE ] VIEW name [ ( column_name [, ...] ) ] AS query |
REINDEX | 索引与统计 | +1 −1 | REINDEX { DATABASE | TABLE | INDEX } name [ FORCE ] |
CREATE INDEX | 索引与统计 | +2 −5 | CREATE [ UNIQUE ] INDEX name ON table [ USING method ] |
DROP INDEX | 索引与统计 | +1 −1 | DROP INDEX name [, ...] [ CASCADE | RESTRICT ] |
CREATE AGGREGATE | 函数与过程 | +1 −1 | STYPE = state_data_type |
CREATE LANGUAGE | 函数与过程 | +1 −1 | CREATE [ TRUSTED ] [ PROCEDURAL ] LANGUAGE name |
CREATE CONVERSION | 类型与运算符 | +1 −1 | CREATE [DEFAULT] CONVERSION name |
DROP CONVERSION | 类型与运算符 | +1 −1 | DROP CONVERSION name [ CASCADE | RESTRICT ] |
CREATE DOMAIN | 类型与运算符 | +3 −2 | CREATE DOMAIN name [AS] data_type |
DROP DOMAIN | 类型与运算符 | +1 −1 | DROP DOMAIN name [, ...] [ CASCADE | RESTRICT ] |
CREATE OPERATOR | 类型与运算符 | +1 −1 | PROCEDURE = funcname |
DROP OPERATOR | 类型与运算符 | +1 −1 | DROP OPERATOR name ( lefttype | NONE , righttype | NONE ) [ CASCADE | RESTRICT ] |
CREATE OPERATOR CLASS | 类型与运算符 | +3 −3 | CREATE OPERATOR CLASS name [ DEFAULT ] FOR TYPE data_type USING index_method AS |
DROP OPERATOR CLASS | 类型与运算符 | +1 −1 | DROP OPERATOR CLASS name USING index_method [ CASCADE | RESTRICT ] |
CREATE TYPE | 类型与运算符 | +9 −6 | CREATE TYPE name AS |
DROP TYPE | 类型与运算符 | +1 −1 | DROP TYPE name [, ...] [ CASCADE | RESTRICT ] |
ALTER DATABASE | 数据库、模式与表空间 | +3 −2 | ALTER DATABASE name SET parameter { TO | = } { value | DEFAULT } |
GRANT | 角色与权限 | +5 −0 | TO { username | GROUP groupname | PUBLIC } [, ...] [ WITH GRANT OPTION ] |
REVOKE | 角色与权限 | +10 −0 | REVOKE [ GRANT OPTION FOR ] |
ALTER GROUP | 角色与权限 | +3 −2 | ALTER GROUP groupname ADD USER username [, ... ] |
CREATE USER | 角色与权限 | +1 −1 | CREATE USER name [ [ WITH ] option [ ... ] ] |
ALTER USER | 角色与权限 | +4 −3 | ALTER USER name [ [ WITH ] option [ ... ] ] |
CREATE CONSTRAINT TRIGGER | 触发器与规则 | +2 −2 | tablename constraint attributes |
CREATE RULE | 触发器与规则 | +1 −4 | DO [ INSTEAD ] { NOTHING | command | ( command ; command ... ) } |
CREATE TRIGGER | 触发器与规则 | +2 −1 | ON table [ FOR [ EACH ] { ROW | STATEMENT } ] |
ALTER TRIGGER | 触发器与规则 | +1 −1 | ALTER TRIGGER name ON table RENAME TO newname |
COPY | 查询与数据操作 | +4 −4 | COPY tablename [ ( column [, ...] ) ] |
EXPLAIN | 查询与数据操作 | +1 −1 | EXPLAIN [ ANALYZE ] [ VERBOSE ] statement |
INSERT | 查询与数据操作 | +0 −1 | — |
LOCK | 查询与数据操作 | +1 −1 | LOCK [ TABLE ] name [, ...] [ IN lockmode MODE ] |
SELECT | 查询与数据操作 | +7 −12 | [ FOR UPDATE [ OF table_name [, ...] ] ] |
UPDATE | 查询与数据操作 | +1 −1 | UPDATE [ ONLY ] table SET column = { expression | DEFAULT } [, ...] |
CLOSE | 游标与预备语句 | +1 −1 | CLOSE name |
DECLARE | 游标与预备语句 | +3 −1 | DECLARE name [ BINARY ] [ INSENSITIVE ] [ [ NO ] SCROLL ] |
FETCH | 游标与预备语句 | +14 −4 | FETCH [ direction { FROM | IN } ] cursorname |
MOVE | 游标与预备语句 | +1 −2 | MOVE [ direction { FROM | IN } ] cursorname |
PREPARE | 游标与预备语句 | +1 −1 | PREPARE plan_name [ (datatype [, ...] ) ] AS statement |
SET CONSTRAINTS | 事务控制 | +1 −1 | SET CONSTRAINTS { ALL | name [, ...] } { DEFERRED | IMMEDIATE } |
SET TRANSACTION | 事务控制 | +2 −0 | [ ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE } ] [ READ WRITE | READ ONLY ] |
START TRANSACTION | 事务控制 | +1 −0 | START TRANSACTION [ ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE } ] [ READ WRITE | READ ONLY ] |
RESET | 会话与参数 | +1 −1 | RESET name |
SET | 会话与参数 | +1 −1 | SET [ SESSION | LOCAL ] name { TO | = } { value | 'value' | DEFAULT } |
UNLISTEN | 会话与参数 | +1 −1 | UNLISTEN { name | * } |
CLUSTER | 维护 | +2 −0 | CLUSTER tablename |
COMMENT | 其它对象 | +2 −2 | { |
TRUNCATEDROP SEQUENCEDROP TABLEDROP VIEWDROP AGGREGATECREATE FUNCTIONDROP FUNCTIONDROP LANGUAGECREATE CASTDROP CASTCREATE DATABASEDROP DATABASECREATE SCHEMADROP SCHEMACREATE GROUPDROP GROUPSET SESSION AUTHORIZATIONDROP USERDROP RULEDROP TRIGGERLOADDELETESELECT INTODEALLOCATEEXECUTEABORTBEGINCOMMITENDROLLBACKLISTENNOTIFYSHOWANALYZECHECKPOINTVACUUM