Skip to content

ALTER SCHEMA

Synopsis

ALTER SCHEMA name RENAME TO new_name
ALTER SCHEMA name SET AUTHORIZATION ( user | USER user | ROLE role )

Description

Change the definition of an existing schema.

Examples

Rename schema web to traffic:

ALTER SCHEMA web RENAME TO traffic

Change owner of schema web to user alice:

ALTER SCHEMA web SET AUTHORIZATION alice

Allow everyone to drop schema and create tables in schema web:

ALTER SCHEMA web SET AUTHORIZATION ROLE PUBLIC

See also

CREATE SCHEMA