pgsql.cc 提供对 postgresql.org 官网内容的中文翻译，由 Pigsty 团队维护。
相对 PostgreSQL 10 的差异；11 共收录 182 条 SQL 命令。
PostgreSQL 11 为历史版本，已结束维护。
语法变化按参考页「语法概要」逐行比较；文件改名独立统计，可能同时有语法或正文变化。
CALL函数与过程
调用一个过程
CREATE PROCEDURE函数与过程
定义一个新过程
ALTER PROCEDURE函数与过程
更改过程的定义
DROP PROCEDURE函数与过程
移除一个过程
ALTER ROUTINE函数与过程
更改一个例程的定义
DROP ROUTINE函数与过程
移除一个例程
| 命令 | 分组 | 变化行数 | 首条新增行 |
|---|---|---|---|
CREATE TABLE | 表与视图 | +7 −0 | [ PARTITION BY { RANGE | LIST | HASH } ( { column_name | ( expression ) } [ COLLATE collation ] [ opclass ] [, ... ] ) ] |
ALTER TABLE | 表与视图 | +28 −0 | ATTACH PARTITION partition_name { FOR VALUES partition_bound_spec | DEFAULT } |
CREATE INDEX | 索引与统计 | +3 −0 | CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] name ] ON [ ONLY ] table_name [ USING method ] |
ALTER INDEX | 索引与统计 | +4 −0 | ALTER INDEX name ATTACH PARTITION index_name |
CREATE AGGREGATE | 函数与过程 | +10 −0 | [ , FINALFUNC_EXTRA ] |
CREATE FUNCTION | 函数与过程 | +0 −1 | — |
CREATE OPERATOR | 类型与运算符 | +1 −0 | {FUNCTION|PROCEDURE} = function_name |
GRANT | 角色与权限 | +2 −1 | ON { { FUNCTION | PROCEDURE | ROUTINE } routine_name [ ( [ [ argmode ] [ arg_name ] arg_type [, ...] ] ) ] [, ...] |
REVOKE | 角色与权限 | +2 −0 | ON { { FUNCTION | PROCEDURE | ROUTINE } function_name [ ( [ [ argmode ] [ arg_name ] arg_type [, ...] ] ) ] [, ...] |
ALTER DEFAULT PRIVILEGES | 角色与权限 | +2 −0 | ON { FUNCTIONS | ROUTINES } |
CREATE GROUP | 角色与权限 | +1 −0 | | [ ENCRYPTED ] PASSWORD 'password' | PASSWORD NULL |
SECURITY LABEL | 角色与权限 | +4 −1 | PROCEDURE procedure_name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] | |
CREATE ROLE | 角色与权限 | +1 −0 | | [ ENCRYPTED ] PASSWORD 'password' | PASSWORD NULL |
ALTER ROLE | 角色与权限 | +1 −0 | | [ ENCRYPTED ] PASSWORD 'password' | PASSWORD NULL |
CREATE USER | 角色与权限 | +1 −0 | | [ ENCRYPTED ] PASSWORD 'password' | PASSWORD NULL |
ALTER USER | 角色与权限 | +1 −0 | | [ ENCRYPTED ] PASSWORD 'password' | PASSWORD NULL |
CREATE EVENT TRIGGER | 触发器与规则 | +1 −0 | EXECUTE { FUNCTION | PROCEDURE } function_name() |
CREATE TRIGGER | 触发器与规则 | +1 −0 | EXECUTE { FUNCTION | PROCEDURE } function_name ( arguments ) |
ALTER EXTENSION | 扩展与访问方法 | +2 −0 | PROCEDURE procedure_name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] | |
CREATE FOREIGN TABLE | 外部数据 | +3 −0 | { FOR VALUES partition_bound_spec | DEFAULT } |
SELECT | 查询与数据操作 | +3 −1 | from_item join_type from_item { ON join_condition | USING ( join_column [, ...] ) } |
ALTER SYSTEM | 会话与参数 | +1 −1 | ALTER SYSTEM SET configuration_parameter { TO | = } { value [, ...] | DEFAULT } |
ANALYZE | 维护 | +3 −1 | ANALYZE [ ( option [, ...] ) ] [ table_and_columns [, ...] ] |
VACUUM | 维护 | +4 −3 | VACUUM [ ( option [, ...] ) ] [ table_and_columns [, ...] ] |
COMMENT | 其它对象 | +4 −1 | PROCEDURE procedure_name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] | |
CREATE MATERIALIZED VIEWDROP TABLECREATE TABLE ASCREATE VIEWREINDEXDROP INDEXCREATE STATISTICSDODROP AGGREGATEALTER FUNCTIONDROP FUNCTIONCREATE LANGUAGECREATE TRANSFORMCREATE COLLATIONCREATE DOMAINALTER DOMAINALTER OPERATORDROP OPERATORCREATE OPERATOR CLASSDROP OPERATOR CLASSCREATE OPERATOR FAMILYALTER OPERATOR FAMILYCREATE TYPEALTER TYPECREATE DATABASEALTER GROUPREASSIGN OWNEDDROP POLICYSET ROLESET SESSION AUTHORIZATIONCREATE RULEALTER TRIGGERLOADCREATE ACCESS METHODCREATE EXTENSIONALTER TEXT SEARCH CONFIGURATIONDROP TEXT SEARCH CONFIGURATIONDROP TEXT SEARCH DICTIONARYDROP TEXT SEARCH PARSERCREATE TEXT SEARCH TEMPLATEDROP TEXT SEARCH TEMPLATEALTER FOREIGN TABLECREATE SERVERDROP SERVERCREATE PUBLICATIONALTER PUBLICATIONCREATE SUBSCRIPTIONDROP SUBSCRIPTIONCOPYDELETEEXPLAININSERTLOCKUPDATESELECT INTODECLAREFETCHPREPAREBEGINCOMMITENDPREPARE TRANSACTIONDISCARDSETUNLISTENALTER LARGE OBJECT