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

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

百科 / SQL 命令 / 10 变更

PostgreSQL 10 SQL 命令变更

相对 PostgreSQL 9.6 的差异；10 共收录 176 条 SQL 命令。

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

换一个对比基准

汇总

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

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

新增命令 9

移除命令 0

  • 这一版没有移除命令。

文件改名 0

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

语法变化 40

命令分组变化行数首条新增行
ALTER MATERIALIZED VIEW表与视图+2 −0SET TABLESPACE new_tablespace
CREATE SEQUENCE表与视图+1 −0[ AS data_type ]
ALTER SEQUENCE表与视图+1 −0[ AS data_type ]
CREATE TABLE表与视图+22 −1[ INHERITS ( parent_table [, ... ] ) ]
ALTER TABLE表与视图+7 −0ALTER TABLE [ IF EXISTS ] name
DROP AGGREGATE函数与过程+1 −0DROP AGGREGATE [ IF EXISTS ] name ( aggregate_signature ) [, ...] [ CASCADE | RESTRICT ]
ALTER FUNCTION函数与过程+5 −0ALTER FUNCTION name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ]
DROP FUNCTION函数与过程+1 −0DROP FUNCTION [ IF EXISTS ] name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] [, ...]
CREATE TRANSFORM函数与过程+2 −0FROM SQL WITH FUNCTION from_sql_function_name [ (argument_type [, ...]) ],
CREATE CAST类型与运算符+1 −0WITH FUNCTION function_name [ (argument_type [, ...]) ]
CREATE COLLATION类型与运算符+5 −0CREATE COLLATION [ IF NOT EXISTS ] name (
ALTER COLLATION类型与运算符+1 −0ALTER COLLATION name REFRESH VERSION
DROP OPERATOR类型与运算符+1 −0DROP OPERATOR [ IF EXISTS ] name ( { left_type | NONE } , { right_type | NONE } ) [, ...] [ CASCADE | RESTRICT ]
ALTER OPERATOR FAMILY类型与运算符+1 −0function_name [ ( argument_type [, ...] ) ]
ALTER TYPE类型与运算符+2 −1ALTER TYPE name ADD VALUE [ IF NOT EXISTS ] new_enum_value [ { BEFORE | AFTER } neighbor_enum_value ]
CREATE DATABASE数据库、模式与表空间+0 −2—
GRANT角色与权限+1 −0ON { FUNCTION function_name [ ( [ [ argmode ] [ arg_name ] arg_type [, ...] ] ) ] [, ...]
REVOKE角色与权限+1 −0ON { FUNCTION function_name [ ( [ [ argmode ] [ arg_name ] arg_type [, ...] ] ) ] [, ...]
ALTER DEFAULT PRIVILEGES角色与权限+8 −0TO { [ GROUP ] role_name | PUBLIC } [, ...] [ WITH GRANT OPTION ]
CREATE GROUP角色与权限+0 −1—
SECURITY LABEL角色与权限+4 −0FUNCTION function_name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] |
CREATE POLICY角色与权限+1 −0[ AS { PERMISSIVE | RESTRICTIVE } ]
CREATE ROLE角色与权限+0 −1—
ALTER ROLE角色与权限+0 −1—
CREATE USER角色与权限+0 −1—
ALTER USER角色与权限+0 −1—
CREATE TRIGGER触发器与规则+2 −0[ REFERENCING { { OLD | NEW } TABLE [ AS ] transition_relation_name } [ ... ] ]
ALTER EXTENSION扩展与访问方法+1 −0FUNCTION function_name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] |
DROP FOREIGN DATA WRAPPER外部数据+1 −0DROP FOREIGN DATA WRAPPER [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
CREATE FOREIGN TABLE外部数据+12 −0CREATE FOREIGN TABLE [ IF NOT EXISTS ] table_name
CREATE SERVER外部数据+1 −0CREATE SERVER [IF NOT EXISTS] server_name [ TYPE 'server_type' ] [ VERSION 'server_version' ]
DROP SERVER外部数据+1 −0DROP SERVER [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
CREATE USER MAPPING外部数据+1 −0CREATE USER MAPPING [IF NOT EXISTS] FOR { user_name | USER | CURRENT_USER | PUBLIC }
EXPLAIN查询与数据操作+1 −0SUMMARY [ boolean ]
INSERT查询与数据操作+3 −0INSERT INTO table_name [ AS alias ] [ ( column_name [, ...] ) ]
UPDATE查询与数据操作+1 −0( column_name [, ...] ) = [ ROW ] ( { expression | DEFAULT } [, ...] ) |
FETCH游标与预备语句+1 −1FETCH [ direction ] [ FROM | IN ] cursor_name
MOVE游标与预备语句+1 −1MOVE [ direction ] [ FROM | IN ] cursor_name
SET会话与参数+1 −1SET [ SESSION | LOCAL ] TIME ZONE { value | 'value' | LOCAL | DEFAULT }
COMMENT其它对象+5 −0FUNCTION function_name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] |

仅正文更新 46

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

TRUNCATEREFRESH MATERIALIZED VIEWCREATE TABLE ASCREATE VIEWREINDEXCREATE INDEXCREATE AGGREGATECREATE FUNCTIONCREATE LANGUAGEDROP LANGUAGECREATE DOMAINALTER DOMAINCREATE OPERATORCREATE OPERATOR CLASSCREATE OPERATOR FAMILYCREATE TYPEALTER DATABASECREATE SCHEMAALTER GROUPALTER POLICYCREATE EVENT TRIGGERCREATE RULELOADCREATE ACCESS METHODCREATE EXTENSIONALTER TEXT SEARCH DICTIONARYCREATE TEXT SEARCH TEMPLATECOPYDELETESELECTVALUESSELECT INTODECLAREBEGINSAVEPOINTSET CONSTRAINTSRELEASE SAVEPOINTPREPARE TRANSACTIONSET TRANSACTIONSTART TRANSACTIONNOTIFYRESETANALYZECHECKPOINTVACUUMALTER LARGE OBJECT