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

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

百科 / SQL 命令 / 9.5 变更

PostgreSQL 9.5 SQL 命令变更

相对 PostgreSQL 9.4 的差异；9.5 共收录 165 条 SQL 命令。

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

换一个对比基准

汇总

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

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

新增命令 6

移除命令 0

  • 这一版没有移除命令。

文件改名 0

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

语法变化 54

命令分组变化行数首条新增行
CREATE MATERIALIZED VIEW表与视图+1 −0CREATE MATERIALIZED VIEW [ IF NOT EXISTS ] table_name
ALTER MATERIALIZED VIEW表与视图+2 −0SET ( storage_parameter [= value] [, ... ] )
CREATE SEQUENCE表与视图+1 −0CREATE [ TEMPORARY | TEMP ] SEQUENCE [ IF NOT EXISTS ] name [ INCREMENT [ BY ] increment ]
ALTER SEQUENCE表与视图+1 −0ALTER SEQUENCE [ IF EXISTS ] name OWNER TO { new_owner | CURRENT_USER | SESSION_USER }
ALTER TABLE表与视图+8 −1DISABLE ROW LEVEL SECURITY
CREATE TABLE AS表与视图+1 −0CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXISTS ] table_name
ALTER VIEW表与视图+1 −0ALTER VIEW [ IF EXISTS ] name OWNER TO { new_owner | CURRENT_USER | SESSION_USER }
REINDEX索引与统计+1 −1REINDEX [ ( VERBOSE ) ] { INDEX | TABLE | SCHEMA | DATABASE | SYSTEM } name
CREATE INDEX索引与统计+2 −0CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] name ] ON table_name [ USING method ]
ALTER INDEX索引与统计+1 −0ALTER INDEX [ IF EXISTS ] name SET ( storage_parameter [= value] [, ... ] )
ALTER AGGREGATE函数与过程+1 −0OWNER TO { new_owner | CURRENT_USER | SESSION_USER }
CREATE FUNCTION函数与过程+1 −0| TRANSFORM { FOR TYPE type_name } [, ... ]
ALTER FUNCTION函数与过程+1 −0OWNER TO { new_owner | CURRENT_USER | SESSION_USER }
ALTER LANGUAGE函数与过程+1 −0ALTER [ PROCEDURAL ] LANGUAGE name OWNER TO { new_owner | CURRENT_USER | SESSION_USER }
ALTER COLLATION类型与运算符+1 −0ALTER COLLATION name OWNER TO { new_owner | CURRENT_USER | SESSION_USER }
ALTER CONVERSION类型与运算符+1 −0ALTER CONVERSION name OWNER TO { new_owner | CURRENT_USER | SESSION_USER }
ALTER DOMAIN类型与运算符+1 −0OWNER TO { new_owner | CURRENT_USER | SESSION_USER }
ALTER OPERATOR类型与运算符+1 −0OWNER TO { new_owner | CURRENT_USER | SESSION_USER }
ALTER OPERATOR CLASS类型与运算符+1 −0OWNER TO { new_owner | CURRENT_USER | SESSION_USER }
ALTER OPERATOR FAMILY类型与运算符+1 −0OWNER TO { new_owner | CURRENT_USER | SESSION_USER }
ALTER TYPE类型与运算符+1 −0ALTER TYPE name OWNER TO { new_owner | CURRENT_USER | SESSION_USER }
CREATE DATABASE数据库、模式与表空间+3 −0[ ALLOW_CONNECTIONS [=] allowconn ]
ALTER DATABASE数据库、模式与表空间+3 −0ALLOW_CONNECTIONS allowconn
CREATE SCHEMA数据库、模式与表空间+6 −3CREATE SCHEMA schema_name [ AUTHORIZATION role_specification ] [ schema_element [ ... ] ]
ALTER SCHEMA数据库、模式与表空间+1 −0ALTER SCHEMA name OWNER TO { new_owner | CURRENT_USER | SESSION_USER }
CREATE TABLESPACE数据库、模式与表空间+1 −1[ OWNER { new_owner | CURRENT_USER | SESSION_USER } ]
ALTER TABLESPACE数据库、模式与表空间+1 −0ALTER TABLESPACE name OWNER TO { new_owner | CURRENT_USER | SESSION_USER }
GRANT角色与权限+19 −14TO role_specification [, ...] [ WITH GRANT OPTION ]
REVOKE角色与权限+20 −14FROM role_specification [, ...]
CREATE GROUP角色与权限+3 −0| REPLICATION | NOREPLICATION
ALTER GROUP角色与权限+5 −2ALTER GROUP role_specification ADD USER user_name [, ... ]
DROP OWNED角色与权限+1 −0DROP OWNED BY { name | CURRENT_USER | SESSION_USER } [, ...] [ CASCADE | RESTRICT ]
REASSIGN OWNED角色与权限+2 −0REASSIGN OWNED BY { old_role | CURRENT_USER | SESSION_USER } [, ...]
CREATE ROLE角色与权限+1 −0| BYPASSRLS | NOBYPASSRLS
ALTER ROLE角色与权限+10 −5ALTER ROLE role_specification [ WITH ] option [ ... ]
CREATE USER角色与权限+1 −0| BYPASSRLS | NOBYPASSRLS
ALTER USER角色与权限+10 −5ALTER USER role_specification [ WITH ] option [ ... ]
ALTER EVENT TRIGGER触发器与规则+1 −0ALTER EVENT TRIGGER name OWNER TO { new_owner | CURRENT_USER | SESSION_USER }
CREATE TRIGGER触发器与规则+1 −1[ NOT DEFERRABLE | [ DEFERRABLE ] [ INITIALLY IMMEDIATE | INITIALLY DEFERRED ] ]
ALTER EXTENSION扩展与访问方法+1 −0TRANSFORM FOR type_name LANGUAGE lang_name |
ALTER TEXT SEARCH CONFIGURATION全文检索+1 −0ALTER TEXT SEARCH CONFIGURATION name OWNER TO { new_owner | CURRENT_USER | SESSION_USER }
ALTER TEXT SEARCH DICTIONARY全文检索+1 −0ALTER TEXT SEARCH DICTIONARY name OWNER TO { new_owner | CURRENT_USER | SESSION_USER }
ALTER FOREIGN DATA WRAPPER外部数据+1 −0ALTER FOREIGN DATA WRAPPER name OWNER TO { new_owner | CURRENT_USER | SESSION_USER }
CREATE FOREIGN TABLE外部数据+6 −0{ column_name data_type [ OPTIONS ( option 'value' [, ... ] ) ] [ COLLATE collation ] [ column_constraint [ ... ] ]
ALTER FOREIGN TABLE外部数据+13 −0ALTER FOREIGN TABLE [ IF EXISTS ] [ ONLY ] name [ * ]
ALTER SERVER外部数据+1 −0ALTER SERVER name OWNER TO { new_owner | CURRENT_USER | SESSION_USER }
ALTER USER MAPPING外部数据+1 −0ALTER USER MAPPING FOR { user_name | USER | CURRENT_USER | SESSION_USER | PUBLIC }
DELETE查询与数据操作+1 −1[ USING from_item [, ...] ]
INSERT查询与数据操作+11 −0INSERT INTO table_name [ AS alias ] [ ( column_name [, ...] ) ]
SELECT查询与数据操作+10 −2[ GROUP BY grouping_element [, ...] ]
UPDATE查询与数据操作+3 −1( column_name [, ...] ) = ( { expression | DEFAULT } [, ...] ) |
SELECT INTO查询与数据操作+0 −1—
COMMENT其它对象+5 −0CONSTRAINT constraint_name ON table_name |
ALTER LARGE OBJECT其它对象+1 −0ALTER LARGE OBJECT large_object_oid OWNER TO { new_owner | CURRENT_USER | SESSION_USER }

仅正文更新 17

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

TRUNCATECREATE TABLECREATE VIEWCREATE LANGUAGECREATE DOMAINCREATE OPERATORCREATE OPERATOR CLASSCREATE TYPESECURITY LABELCREATE EVENT TRIGGERCREATE RULECREATE EXTENSIONCOPYLOCKANALYZECLUSTERVACUUM