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

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

百科 / SQL 命令 / 14 变更

PostgreSQL 14 SQL 命令变更

相对 PostgreSQL 13 的差异；14 共收录 182 条 SQL 命令。

换一个对比基准

汇总

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

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

新增命令 0

  • 这一版没有新增命令。

移除命令 0

  • 这一版没有移除命令。

文件改名 0

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

语法变化 55

命令分组变化行数首条新增行
ALTER MATERIALIZED VIEW表与视图+2 −0ALTER [ COLUMN ] column_name SET COMPRESSION compression_method
ALTER SEQUENCE表与视图+1 −0ALTER SEQUENCE [ IF EXISTS ] name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
CREATE TABLE表与视图+2 −0{ column_name data_type [ COMPRESSION compression_method ] [ COLLATE collation ] [ column_constraint [ ... ] ]
ALTER TABLE表与视图+3 −0DETACH PARTITION partition_name [ CONCURRENTLY | FINALIZE ]
ALTER VIEW表与视图+1 −0ALTER VIEW [ IF EXISTS ] name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
REINDEX索引与统计+3 −0CONCURRENTLY [ boolean ]
CREATE STATISTICS索引与统计+4 −0CREATE STATISTICS [ IF NOT EXISTS ] statistics_name
ALTER STATISTICS索引与统计+1 −0ALTER STATISTICS name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
ALTER AGGREGATE函数与过程+1 −0OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
CREATE FUNCTION函数与过程+1 −0| sql_body
ALTER FUNCTION函数与过程+1 −0OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
ALTER LANGUAGE函数与过程+1 −0ALTER [ PROCEDURAL ] LANGUAGE name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
CREATE PROCEDURE函数与过程+1 −0| sql_body
ALTER PROCEDURE函数与过程+1 −0OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
ALTER ROUTINE函数与过程+1 −0OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
ALTER COLLATION类型与运算符+1 −0ALTER COLLATION name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
ALTER CONVERSION类型与运算符+1 −0ALTER CONVERSION name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
ALTER DOMAIN类型与运算符+1 −0OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
ALTER OPERATOR类型与运算符+1 −3OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
DROP OPERATOR类型与运算符+0 −1—
ALTER OPERATOR CLASS类型与运算符+1 −0OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
ALTER OPERATOR FAMILY类型与运算符+1 −0OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
CREATE TYPE类型与运算符+3 −0[ , MULTIRANGE_TYPE_NAME = multirange_type_name ]
ALTER TYPE类型与运算符+1 −0ALTER TYPE name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
ALTER DATABASE数据库、模式与表空间+1 −0ALTER DATABASE name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
CREATE SCHEMA数据库、模式与表空间+2 −0| CURRENT_ROLE
ALTER SCHEMA数据库、模式与表空间+1 −0ALTER SCHEMA name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
CREATE TABLESPACE数据库、模式与表空间+1 −0[ OWNER { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER } ]
ALTER TABLESPACE数据库、模式与表空间+1 −0ALTER TABLESPACE name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
GRANT角色与权限+19 −0[ GRANTED BY role_specification ]
REVOKE角色与权限+28 −0FROM role_specification [, ...]
ALTER GROUP角色与权限+2 −0| CURRENT_ROLE
DROP OWNED角色与权限+1 −0DROP OWNED BY { name | CURRENT_ROLE | CURRENT_USER | SESSION_USER } [, ...] [ CASCADE | RESTRICT ]
REASSIGN OWNED角色与权限+2 −0REASSIGN OWNED BY { old_role | CURRENT_ROLE | CURRENT_USER | SESSION_USER } [, ...]
CREATE POLICY角色与权限+1 −0[ TO { role_name | PUBLIC | CURRENT_ROLE | CURRENT_USER | SESSION_USER } [, ...] ]
ALTER POLICY角色与权限+1 −0[ TO { role_name | PUBLIC | CURRENT_ROLE | CURRENT_USER | SESSION_USER } [, ...] ]
ALTER ROLE角色与权限+2 −0| CURRENT_ROLE
ALTER USER角色与权限+2 −0| CURRENT_ROLE
ALTER EVENT TRIGGER触发器与规则+1 −0ALTER EVENT TRIGGER name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
CREATE TRIGGER触发器与规则+1 −0CREATE [ OR REPLACE ] [ CONSTRAINT ] TRIGGER name { BEFORE | AFTER | INSTEAD OF } { event [ OR ... ] }
ALTER TEXT SEARCH CONFIGURATION全文检索+1 −0ALTER TEXT SEARCH CONFIGURATION name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
ALTER TEXT SEARCH DICTIONARY全文检索+1 −0ALTER TEXT SEARCH DICTIONARY name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
ALTER FOREIGN DATA WRAPPER外部数据+1 −0ALTER FOREIGN DATA WRAPPER name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
ALTER FOREIGN TABLE外部数据+2 −0ADD [ COLUMN ] [ IF NOT EXISTS ] column_name data_type [ COLLATE collation ] [ column_constraint [ ... ] ]
ALTER SERVER外部数据+1 −0ALTER SERVER name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
CREATE USER MAPPING外部数据+1 −0CREATE USER MAPPING [ IF NOT EXISTS ] FOR { user_name | USER | CURRENT_ROLE | CURRENT_USER | PUBLIC }
ALTER USER MAPPING外部数据+1 −0ALTER USER MAPPING FOR { user_name | USER | CURRENT_ROLE | CURRENT_USER | SESSION_USER | PUBLIC }
DROP USER MAPPING外部数据+1 −0DROP USER MAPPING [ IF EXISTS ] FOR { user_name | USER | CURRENT_ROLE | CURRENT_USER | PUBLIC } SERVER server_name
ALTER PUBLICATION逻辑复制+1 −0ALTER PUBLICATION name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
ALTER SUBSCRIPTION逻辑复制+4 −1ALTER SUBSCRIPTION name SET PUBLICATION publication_name [, ...] [ WITH ( publication_option [= value] [, ... ] ) ]
SELECT查询与数据操作+4 −0[ GROUP BY [ ALL | DISTINCT ] grouping_element [, ...] ]
DECLARE游标与预备语句+1 −0DECLARE name [ BINARY ] [ ASENSITIVE | INSENSITIVE ] [ [ NO ] SCROLL ]
CLUSTER维护+3 −0CLUSTER ( option [, ...] ) table_name [ USING index_name ]
VACUUM维护+2 −0INDEX_CLEANUP { AUTO | ON | OFF }
ALTER LARGE OBJECT其它对象+1 −0ALTER LARGE OBJECT large_object_oid OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }

仅正文更新 63

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

TRUNCATECREATE MATERIALIZED VIEWCREATE SEQUENCEDROP TABLECREATE TABLE ASCREATE VIEWCREATE INDEXALTER INDEXCALLCREATE AGGREGATECREATE LANGUAGEDROP LANGUAGEDROP PROCEDUREDROP ROUTINECREATE TRANSFORMDROP TRANSFORMCREATE CASTCREATE COLLATIONCREATE CONVERSIONCREATE OPERATORCREATE OPERATOR CLASSCREATE OPERATOR FAMILYCREATE DATABASEDROP GROUPSECURITY LABELCREATE ROLEDROP ROLESET ROLESET SESSION AUTHORIZATIONCREATE USERDROP USERCREATE EVENT TRIGGERCREATE RULELOADCREATE ACCESS METHODCREATE EXTENSIONALTER EXTENSIONDROP EXTENSIONCREATE FOREIGN TABLECREATE PUBLICATIONCREATE SUBSCRIPTIONDROP SUBSCRIPTIONCOPYEXPLAININSERTLOCKSELECT INTOFETCHPREPAREABORTBEGINROLLBACKSAVEPOINTPREPARE TRANSACTIONSET TRANSACTIONSTART TRANSACTIONRESETSETSHOWALTER SYSTEMANALYZECHECKPOINTCOMMENT