Postgresql 中文操作指南

ALTER SCHEMA

ALTER SCHEMA — 更改架构的定义

ALTER SCHEMA — change the definition of a schema

Synopsis

ALTER SCHEMA name RENAME TO new_name
ALTER SCHEMA name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }

Description

ALTER SCHEMA 更改架构的定义。

ALTER SCHEMA changes the definition of a schema.

你必须拥有架构才能使用 ALTER SCHEMA 。要重新命名架构，你还必须拥有数据库的 CREATE 权限。要更改所有者，你必须能够 SET ROLE 到新的拥有角色，并且该角色必须拥有数据库的 CREATE 权限。（请注意，超级用户自动拥有所有这些权限。）

You must own the schema to use ALTER SCHEMA. To rename a schema you must also have the CREATE privilege for the database. To alter the owner, you must be able to SET ROLE to the new owning role, and that role must have the CREATE privilege for the database. (Note that superusers have all these privileges automatically.)

Parameters

name
- The name of an existing schema.
new_name
- The new name of the schema. The new name cannot begin with pg_, as such names are reserved for system schemas.
new_owner
- The new owner of the schema.

Compatibility

SQL 标准中没有 ALTER SCHEMA 语句。

There is no ALTER SCHEMA statement in the SQL standard.