PostgreSQL 文档检索

ALTER DEFAULT PRIVILEGES章节正文PG18ALTER DEFAULT PRIVILEGES ALTER DEFAULT PRIVILEGES — 定义默认访问权限大纲 ALTER DEFAULT PRIVILEGES [ FOR { ROLE | USER } target_role [, ...] ] [ IN SCHEMA schema_name [, ...] ] abbreviated_grant_or_rev…ALTER DEFAULT PRIVILEGES ALTER DOMAINSQL 命令与语法本站词条更改一个域的定义 ALTER DOMAIN name { SET DEFAULT expression | DROP DEFAULT } ALTER DOMAIN name { SET | DROP } NOT NULL ALTER DOMAIN name ADD domain_constraint [ NOT VALID ] ALTER DOMAIN name DROP C…SQL 命令 · 类型与运算符 ALTER DOMAIN章节正文PG18ALTER DOMAIN ALTER DOMAIN — 更改一个域的定义大纲 ALTER DOMAIN name { SET DEFAULT expression | DROP DEFAULT } ALTER DOMAIN name { SET | DROP } NOT NULL ALTER DOMAIN name ADD domain_constraint [ NOT VAL…ALTER DOMAIN ALTER EVENT TRIGGERSQL 命令与语法本站词条更改事件触发器的定义 ALTER EVENT TRIGGER name DISABLE ALTER EVENT TRIGGER name ENABLE [ REPLICA | ALWAYS ] ALTER EVENT TRIGGER name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }…SQL 命令 · 触发器与规则 ALTER EVENT TRIGGER章节正文PG18ALTER EVENT TRIGGER ALTER EVENT TRIGGER — 更改事件触发器的定义大纲 ALTER EVENT TRIGGER name DISABLE ALTER EVENT TRIGGER name ENABLE [ REPLICA | ALWAYS ] ALTER EVENT TRIGGER name OWNER TO { new_owner | C…ALTER EVENT TRIGGER ALTER EXTENSIONSQL 命令与语法本站词条更改扩展的定义 ALTER EXTENSION name UPDATE [ TO new_version ] ALTER EXTENSION name SET SCHEMA new_schema ALTER EXTENSION name ADD member_object ALTER EXTENSION name DROP member_object 其中 member_ob…SQL 命令 · 扩展与访问方法 ALTER EXTENSION章节正文PG18ALTER EXTENSION ALTER EXTENSION — 更改扩展的定义大纲 ALTER EXTENSION name UPDATE [ TO new_version ] ALTER EXTENSION name SET SCHEMA new_schema ALTER EXTENSION name ADD member_object ALTER EXTENSION n…ALTER EXTENSION ALTER FOREIGN DATA WRAPPERSQL 命令与语法本站词条更改外部数据包装器的定义 ALTER FOREIGN DATA WRAPPER name [ HANDLER handler_function | NO HANDLER ] [ VALIDATOR validator_function | NO VALIDATOR ] [ CONNECTION connection_function | NO CONNECTION ] [ O…SQL 命令 · 外部数据 ALTER FOREIGN DATA WRAPPER章节正文PG18ALTER FOREIGN DATA WRAPPER ALTER FOREIGN DATA WRAPPER — 更改外部数据包装器的定义大纲 ALTER FOREIGN DATA WRAPPER name [ HANDLER handler_function | NO HANDLER ] [ VALIDATOR validator_function | NO VALIDATOR…ALTER FOREIGN DATA WRAPPER ALTER FOREIGN TABLESQL 命令与语法本站词条更改外部表的定义 ALTER FOREIGN TABLE [ IF EXISTS ] [ ONLY ] name [ * ] action [, ... ] ALTER FOREIGN TABLE [ IF EXISTS ] [ ONLY ] name [ * ] RENAME [ COLUMN ] column_name TO new_column_name ALTER F…SQL 命令 · 外部数据 ALTER FOREIGN TABLE章节正文PG18ALTER FOREIGN TABLE ALTER FOREIGN TABLE — 更改外部表的定义大纲 ALTER FOREIGN TABLE [ IF EXISTS ] [ ONLY ] name [ * ] action [, ... ] ALTER FOREIGN TABLE [ IF EXISTS ] [ ONLY ] name [ * ] RENAME [ COLU…ALTER FOREIGN TABLE ALTER FUNCTIONSQL 命令与语法本站词条更改函数的定义 ALTER FUNCTION name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] action [ ... ] [ RESTRICT ] ALTER FUNCTION name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] RENAME TO…SQL 命令 · 函数与过程 ALTER FUNCTION章节正文PG18ALTER FUNCTION ALTER FUNCTION — 更改函数的定义大纲 ALTER FUNCTION name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] action [ ... ] [ RESTRICT ] ALTER FUNCTION name [ ( [ [ argmode ] [ argname …ALTER FUNCTION ALTER GROUPSQL 命令与语法本站词条更改角色名称或成员资格 ALTER GROUP role_specification ADD USER user_name [, ... ] ALTER GROUP role_specification DROP USER user_name [, ... ] 其中 role_specification 可以是： role_name | CURRENT_ROLE | CUR…SQL 命令 · 角色与权限 ALTER GROUP章节正文PG18ALTER GROUP ALTER GROUP — 更改角色名称或成员资格大纲 ALTER GROUP role_specification ADD USER user_name [, ... ] ALTER GROUP role_specification DROP USER user_name [, ... ] 其中 role_specification 可以是： role…ALTER GROUP ALTER INDEXSQL 命令与语法本站词条更改索引的定义 ALTER INDEX [ IF EXISTS ] name RENAME TO new_name ALTER INDEX [ IF EXISTS ] name SET TABLESPACE tablespace_name ALTER INDEX name ATTACH PARTITION index_name ALTER INDEX name [ NO ] …SQL 命令 · 索引与统计 ALTER INDEX章节正文PG18ALTER INDEX ALTER INDEX — 更改索引的定义大纲 ALTER INDEX [ IF EXISTS ] name RENAME TO new_name ALTER INDEX [ IF EXISTS ] name SET TABLESPACE tablespace_name ALTER INDEX name ATTACH PARTITION index_na…ALTER INDEX ALTER LANGUAGESQL 命令与语法本站词条更改一种过程语言的定义 ALTER [ PROCEDURAL ] LANGUAGE name RENAME TO new_name ALTER [ PROCEDURAL ] LANGUAGE name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER } 函数与过程SQL 命令 · 函数与过程 ALTER LANGUAGE章节正文PG18ALTER LANGUAGE ALTER LANGUAGE — 更改一种过程语言的定义大纲 ALTER [ PROCEDURAL ] LANGUAGE name RENAME TO new_name ALTER [ PROCEDURAL ] LANGUAGE name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SE…ALTER LANGUAGE ALTER LARGE OBJECTSQL 命令与语法本站词条更改一个大对象的定义 ALTER LARGE OBJECT large_object_oid OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER } 其它对象SQL 命令 · 其它对象 ALTER LARGE OBJECT章节正文PG18ALTER LARGE OBJECT ALTER LARGE OBJECT — 更改一个大对象的定义大纲 ALTER LARGE OBJECT large_object_oid OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }ALTER LARGE OBJECT ALTER MATERIALIZED VIEWSQL 命令与语法本站词条更改一个物化视图的定义 ALTER MATERIALIZED VIEW [ IF EXISTS ] name action [, ... ] ALTER MATERIALIZED VIEW name [ NO ] DEPENDS ON EXTENSION extension_name ALTER MATERIALIZED VIEW [ IF EXISTS ] name REN…SQL 命令 · 表与视图 ALTER MATERIALIZED VIEW章节正文PG18ALTER MATERIALIZED VIEW ALTER MATERIALIZED VIEW — 更改一个物化视图的定义大纲 ALTER MATERIALIZED VIEW [ IF EXISTS ] name action [, ... ] ALTER MATERIALIZED VIEW name [ NO ] DEPENDS ON EXTENSION extension_…ALTER MATERIALIZED VIEW ALTER OPERATORSQL 命令与语法本站词条更改一个操作符的定义 ALTER OPERATOR name ( { left_type | NONE } , right_type ) OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER } ALTER OPERATOR name ( { left_type | NONE } , right_…SQL 命令 · 类型与运算符 ALTER OPERATOR章节正文PG18ALTER OPERATOR ALTER OPERATOR — 更改一个操作符的定义大纲 ALTER OPERATOR name ( { left_type | NONE } , right_type ) OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER } ALTER OPERATOR name…ALTER OPERATOR ALTER OPERATOR CLASSSQL 命令与语法本站词条更改一个操作符类的定义 ALTER OPERATOR CLASS name USING index_method RENAME TO new_name ALTER OPERATOR CLASS name USING index_method OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }…SQL 命令 · 类型与运算符 ALTER OPERATOR CLASS章节正文PG18ALTER OPERATOR CLASS ALTER OPERATOR CLASS — 更改一个操作符类的定义大纲 ALTER OPERATOR CLASS name USING index_method RENAME TO new_name ALTER OPERATOR CLASS name USING index_method OWNER TO { new_owner | …ALTER OPERATOR CLASS ALTER OPERATOR FAMILYSQL 命令与语法本站词条更改一个操作符族的定义 ALTER OPERATOR FAMILY name USING index_method ADD { OPERATOR strategy_number operator_name ( op_type, op_type ) [ FOR SEARCH | FOR ORDER BY sort_family_name ] | FUNCTION support…SQL 命令 · 类型与运算符 ALTER OPERATOR FAMILY章节正文PG18ALTER OPERATOR FAMILY ALTER OPERATOR FAMILY — 更改一个操作符族的定义大纲 ALTER OPERATOR FAMILY name USING index_method ADD { OPERATOR strategy_number operator_name ( op_type, op_type ) [ FOR SEARCH | FOR…ALTER OPERATOR FAMILY ALTER POLICYSQL 命令与语法本站词条更改一条行级安全策略的定义 ALTER POLICY name ON table_name RENAME TO new_name ALTER POLICY name ON table_name [ TO { role_name | PUBLIC | CURRENT_ROLE | CURRENT_USER | SESSION_USER } [, ...] ] [ USING …SQL 命令 · 角色与权限 ALTER POLICY章节正文PG18ALTER POLICY ALTER POLICY — 更改一条行级安全策略的定义大纲 ALTER POLICY name ON table_name RENAME TO new_name ALTER POLICY name ON table_name [ TO { role_name | PUBLIC | CURRENT_ROLE | CURRENT_USER | SESSI…ALTER POLICY ALTER PROCEDURESQL 命令与语法本站词条更改过程的定义 ALTER PROCEDURE name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] action [ ... ] [ RESTRICT ] ALTER PROCEDURE name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] RENAME …SQL 命令 · 函数与过程 ALTER PROCEDURE章节正文PG18ALTER PROCEDURE ALTER PROCEDURE — 更改过程的定义大纲 ALTER PROCEDURE name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] action [ ... ] [ RESTRICT ] ALTER PROCEDURE name [ ( [ [ argmode ] [ argn…ALTER PROCEDURE ALTER PUBLICATIONSQL 命令与语法本站词条修改发布的定义 ALTER PUBLICATION name ADD publication_object [, ...] ALTER PUBLICATION name DROP publication_drop_object [, ...] ALTER PUBLICATION name SET { publication_object [, ...] | publicati…SQL 命令 · 逻辑复制 ALTER PUBLICATION章节正文PG18ALTER PUBLICATION ALTER PUBLICATION — 修改发布的定义大纲 ALTER PUBLICATION name ADD publication_object [, ...] ALTER PUBLICATION name SET publication_object [, ...] ALTER PUBLICATION name DROP public…ALTER PUBLICATION ALTER ROLESQL 命令与语法本站词条更改数据库角色 ALTER ROLE role_specification [ WITH ] option [ ... ] 其中option可以是： SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE | NOCREATEROLE | INHERIT | NOINHERIT | LOGIN | NOLO…SQL 命令 · 角色与权限 ALTER ROLE章节正文PG18ALTER ROLE ALTER ROLE — 更改数据库角色大纲 ALTER ROLE role_specification [ WITH ] option [ ... ] 其中option可以是： SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE | NOCREATEROLE | INHERIT | N…ALTER ROLE ALTER ROUTINESQL 命令与语法本站词条更改一个例程的定义 ALTER ROUTINE name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] action [ ... ] [ RESTRICT ] ALTER ROUTINE name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] RENAME TO…SQL 命令 · 函数与过程 ALTER ROUTINE章节正文PG18ALTER ROUTINE ALTER ROUTINE — 更改一个例程的定义大纲 ALTER ROUTINE name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] action [ ... ] [ RESTRICT ] ALTER ROUTINE name [ ( [ [ argmode ] [ argname ] …ALTER ROUTINE ALTER RULESQL 命令与语法本站词条修改一条重写规则的定义 ALTER RULE name ON table_name RENAME TO new_name 触发器与规则SQL 命令 · 触发器与规则