pgsql.cc 提供对 postgresql.org 官网内容的中文翻译，由 Pigsty 团队维护。
相对 PostgreSQL 8.2 的差异；8.3 共收录 129 条 SQL 命令。
PostgreSQL 8.3 为历史版本，已结束维护。
语法变化按参考页「语法概要」逐行比较；文件改名独立统计，可能同时有语法或正文变化。
ALTER VIEW表与视图
更改视图的定义
CREATE OPERATOR FAMILY类型与运算符
定义一个新的操作符族
ALTER OPERATOR FAMILY类型与运算符
更改一个操作符族的定义
DROP OPERATOR FAMILY类型与运算符
移除一个操作符族
CREATE TEXT SEARCH CONFIGURATION全文检索
定义一个新的文本搜索配置
ALTER TEXT SEARCH CONFIGURATION全文检索
更改一个文本搜索配置的定义
DROP TEXT SEARCH CONFIGURATION全文检索
移除一个文本检索配置
CREATE TEXT SEARCH DICTIONARY全文检索
定义一个新的文本搜索字典
ALTER TEXT SEARCH DICTIONARY全文检索
更改一个文本搜索字典的定义
DROP TEXT SEARCH DICTIONARY全文检索
移除一个文本检索词典
定义一个新的全文检索解析器
更改一个全文检索解析器的定义
移除一个文本检索解析器
CREATE TEXT SEARCH TEMPLATE全文检索
定义一个新的全文检索模板
ALTER TEXT SEARCH TEMPLATE全文检索
更改一个文本搜索模板的定义
移除一个文本检索模板
DISCARD会话与参数
丢弃会话状态
| 命令 | 分组 | 变化行数 | 首条新增行 |
|---|---|---|---|
ALTER SEQUENCE | 表与视图 | +2 −0 | ALTER SEQUENCE name RENAME TO new_name |
CREATE TABLE | 表与视图 | +1 −0 | | LIKE parent_table [ { INCLUDING | EXCLUDING } { DEFAULTS | CONSTRAINTS | INDEXES } ] ... } |
ALTER TABLE | 表与视图 | +6 −0 | ENABLE REPLICA TRIGGER trigger_name |
CREATE INDEX | 索引与统计 | +1 −0 | ( { column | ( expression ) } [ opclass ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ] [, ...] ) |
CREATE FUNCTION | 函数与过程 | +4 −0 | | COST execution_cost |
ALTER FUNCTION | 函数与过程 | +6 −1 | COST execution_cost |
ALTER LANGUAGE | 函数与过程 | +2 −0 | ALTER [ PROCEDURAL ] LANGUAGE name RENAME TO newname |
CREATE OPERATOR | 类型与运算符 | +0 −2 | — |
CREATE OPERATOR CLASS | 类型与运算符 | +2 −0 | USING index_method [ FAMILY family_name ] AS |
CREATE TYPE | 类型与运算符 | +6 −0 | ( attribute_name data_type [, ... ] ) |
ALTER DATABASE | 数据库、模式与表空间 | +6 −4 | ALTER DATABASE name RENAME TO newname |
GRANT | 角色与权限 | +8 −8 | TO { [ GROUP ] rolename | PUBLIC } [, ...] [ WITH GRANT OPTION ] |
REVOKE | 角色与权限 | +8 −8 | FROM { [ GROUP ] rolename | PUBLIC } [, ...] |
ALTER ROLE | 角色与权限 | +3 −0 | ALTER ROLE name SET configuration_parameter FROM CURRENT |
ALTER USER | 角色与权限 | +3 −0 | ALTER USER name SET configuration_parameter FROM CURRENT |
DELETE | 查询与数据操作 | +2 −0 | DELETE FROM [ ONLY ] table [ * ] [ [ AS ] alias ] |
SELECT | 查询与数据操作 | +1 −0 | [ ORDER BY expression [ ASC | DESC | USING operator ] [ NULLS { FIRST | LAST } ] [, ...] ] |
UPDATE | 查询与数据操作 | +2 −0 | UPDATE [ ONLY ] table [ * ] [ [ AS ] alias ] |
SELECT INTO | 查询与数据操作 | +1 −0 | [ ORDER BY expression [ ASC | DESC | USING operator ] [ NULLS { FIRST | LAST } ] [, ...] ] |
CLOSE | 游标与预备语句 | +1 −0 | CLOSE { name | ALL } |
DEALLOCATE | 游标与预备语句 | +1 −0 | DEALLOCATE [ PREPARE ] { name | ALL } |
DECLARE | 游标与预备语句 | +0 −1 | — |
CLUSTER | 维护 | +1 −1 | CLUSTER tablename [ USING indexname ] |
COMMENT | 其它对象 | +5 −0 | OPERATOR FAMILY object_name USING index_method | |
TRUNCATECREATE SEQUENCEDROP SEQUENCEDROP TABLECREATE TABLE ASCREATE VIEWDROP VIEWREINDEXALTER INDEXCREATE AGGREGATEDROP AGGREGATEDROP FUNCTIONCREATE LANGUAGEDROP LANGUAGECREATE CASTCREATE CONVERSIONDROP CONVERSIONCREATE DOMAINALTER DOMAINDROP DOMAINALTER OPERATOR CLASSDROP OPERATOR CLASSDROP TYPECREATE DATABASECREATE SCHEMACREATE TABLESPACEDROP TABLESPACEDROP OWNEDCREATE ROLESET ROLESET SESSION AUTHORIZATIONCREATE CONSTRAINT TRIGGERCREATE RULECREATE TRIGGERDROP TRIGGERLOADCOPYEXPLAININSERTLOCKVALUESFETCHPREPAREBEGINSET CONSTRAINTSRELEASE SAVEPOINTROLLBACK TO SAVEPOINTPREPARE TRANSACTIONSET TRANSACTIONSTART TRANSACTIONNOTIFYRESETSETSHOWUNLISTENANALYZECHECKPOINTVACUUM