ALTER SCHEMA¶

Synopsis¶

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

Change the definition of an existing schema.

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