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

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

百科 / SQL 命令 / 8.0 变更

PostgreSQL 8.0 SQL 命令变更

相对 PostgreSQL 7.4 的差异；8.0 共收录 102 条 SQL 命令。

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

换一个对比基准

汇总

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

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

新增命令 9

移除命令 0

  • 这一版没有移除命令。

文件改名 0

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

语法变化 27

命令分组变化行数首条新增行
CREATE TABLE表与视图+5 −0[ TABLESPACE tablespace ]
ALTER TABLE表与视图+14 −18action [, ... ]
CREATE TABLE AS表与视图+1 −0CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name [ (column_name [, ...] ) ] [ [ WITH | WITHOUT ] OIDS ]
CREATE INDEX索引与统计+2 −0[ TABLESPACE tablespace ]
ALTER AGGREGATE函数与过程+1 −0ALTER AGGREGATE name ( type ) OWNER TO newowner
CREATE FUNCTION函数与过程+1 −0CREATE [ OR REPLACE ] FUNCTION name ( [ [ argname ] argtype [, ...] ] )
ALTER FUNCTION函数与过程+1 −0ALTER FUNCTION name ( [ type [, ...] ] ) OWNER TO newowner
CREATE CAST类型与运算符+1 −1WITH FUNCTION funcname (argtypes)
ALTER CONVERSION类型与运算符+1 −0ALTER CONVERSION name OWNER TO newowner
DROP OPERATOR类型与运算符+1 −0DROP OPERATOR name ( { lefttype | NONE } , { righttype | NONE } ) [ CASCADE | RESTRICT ]
ALTER OPERATOR CLASS类型与运算符+1 −0ALTER OPERATOR CLASS name USING index_method OWNER TO newowner
CREATE TYPE类型与运算符+2 −0[ , SEND = send_function ]
CREATE DATABASE数据库、模式与表空间+1 −2[ TABLESPACE [=] tablespace ] ]
ALTER DATABASE数据库、模式与表空间+1 −0ALTER DATABASE name OWNER TO new_owner
ALTER SCHEMA数据库、模式与表空间+1 −0ALTER SCHEMA name OWNER TO newowner
GRANT角色与权限+3 −0GRANT { CREATE | ALL [ PRIVILEGES ] }
REVOKE角色与权限+5 −0REVOKE [ GRANT OPTION FOR ]
CREATE USER角色与权限+2 −2| [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'
ALTER USER角色与权限+3 −2CREATEDB | NOCREATEDB
CREATE RULE触发器与规则+1 −0DO [ ALSO | INSTEAD ] { NOTHING | command | ( command ; command ... ) }
COPY查询与数据操作+7 −0[ NULL [ AS ] 'null string' ]
LOCK查询与数据操作+1 −0LOCK [ TABLE ] name [, ...] [ IN lockmode MODE ] [ NOWAIT ]
BEGIN事务控制+4 −0BEGIN [ WORK | TRANSACTION ] [ transaction_mode [, ...] ]
SET TRANSACTION事务控制+4 −2SET TRANSACTION transaction_mode [, ...]
START TRANSACTION事务控制+3 −1START TRANSACTION [ transaction_mode [, ...] ]
VACUUM维护+2 −2VACUUM [ FULL | FREEZE ] [ VERBOSE ] [ table ]
COMMENT其它对象+7 −0CAST (sourcetype AS targettype) |

仅正文更新 44

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

CREATE SEQUENCEALTER SEQUENCEDROP SEQUENCEDROP TABLECREATE VIEWDROP VIEWREINDEXCREATE AGGREGATECREATE LANGUAGECREATE DOMAINALTER DOMAINCREATE OPERATORCREATE OPERATOR CLASSDROP TYPECREATE SCHEMACREATE GROUPALTER GROUPDROP GROUPDROP USERCREATE TRIGGERDROP TRIGGERLOADDELETEEXPLAININSERTSELECTUPDATESELECT INTOCLOSEDEALLOCATEDECLAREEXECUTEFETCHMOVEPREPAREROLLBACKSET CONSTRAINTSNOTIFYRESETSETSHOWANALYZECHECKPOINTCLUSTER