pgsql.cc 提供对 postgresql.org 官网内容的中文翻译，由 Pigsty 团队维护。
相对 PostgreSQL 9.3 的差异；9.4 共收录 159 条 SQL 命令。
PostgreSQL 9.4 为历史版本，已结束维护。
语法变化按参考页「语法概要」逐行比较；文件改名独立统计，可能同时有语法或正文变化。
ALTER SYSTEM会话与参数
更改服务器配置参数
| 命令 | 分组 | 变化行数 | 首条新增行 |
|---|---|---|---|
ALTER MATERIALIZED VIEW | 表与视图 | +2 −1 | ALTER MATERIALIZED VIEW ALL IN TABLESPACE name [ OWNED BY role_name [, ... ] ] |
REFRESH MATERIALIZED VIEW | 表与视图 | +1 −0 | REFRESH MATERIALIZED VIEW [ CONCURRENTLY ] name |
ALTER TABLE | 表与视图 | +4 −0 | ALTER TABLE ALL IN TABLESPACE name [ OWNED BY role_name [, ... ] ] |
CREATE VIEW | 表与视图 | +1 −0 | [ WITH [ CASCADED | LOCAL ] CHECK OPTION ] |
ALTER INDEX | 索引与统计 | +2 −0 | ALTER INDEX ALL IN TABLESPACE name [ OWNED BY role_name [, ... ] ] |
CREATE AGGREGATE | 函数与过程 | +33 −1 | CREATE AGGREGATE name ( [ argmode ] [ argname ] arg_data_type [ , ... ] ) ( |
ALTER AGGREGATE | 函数与过程 | +6 −3 | ALTER AGGREGATE name ( aggregate_signature ) RENAME TO new_name |
DROP AGGREGATE | 函数与过程 | +4 −1 | DROP AGGREGATE [ IF EXISTS ] name ( aggregate_signature ) [ CASCADE | RESTRICT ] |
CREATE TABLESPACE | 数据库、模式与表空间 | +1 −0 | [ WITH ( tablespace_option = value [, ... ] ) ] |
SECURITY LABEL | 角色与权限 | +4 −1 | AGGREGATE aggregate_name ( aggregate_signature ) | |
CREATE RULE | 触发器与规则 | +1 −0 | SELECT | INSERT | UPDATE | DELETE |
ALTER EXTENSION | 扩展与访问方法 | +4 −1 | AGGREGATE aggregate_name ( aggregate_signature ) | |
ALTER FOREIGN TABLE | 外部数据 | +4 −0 | DISABLE TRIGGER [ trigger_name | ALL | USER ] |
COPY | 查询与数据操作 | +1 −0 | FORCE_NULL ( column_name [, ...] ) |
SELECT | 查询与数据操作 | +5 −1 | [ * | expression [ [ AS ] output_name ] [, ...] ] |
DISCARD | 会话与参数 | +1 −0 | DISCARD { ALL | PLANS | SEQUENCES | TEMPORARY | TEMP } |
COMMENT | 其它对象 | +4 −1 | AGGREGATE aggregate_name ( aggregate_signature ) | |
CREATE TABLECREATE TABLE ASALTER VIEWREINDEXCREATE INDEXDROP INDEXCREATE FUNCTIONCREATE LANGUAGECREATE CASTCREATE DOMAINALTER DOMAINCREATE TYPECREATE DATABASEALTER TABLESPACEALTER DEFAULT PRIVILEGESDROP OWNEDREASSIGN OWNEDSET ROLECREATE TRIGGERCREATE FOREIGN TABLEEXPLAINSELECT INTOABORTROLLBACKSET CONSTRAINTSSET TRANSACTIONSETANALYZEVACUUMALTER LARGE OBJECT