ALTER SCHEMA

ALTER SCHEMA

7

SQL - Language Statements

ALTER SCHEMA

change the definition of a schema

ALTER SCHEMA

name

RENAME TO

new\_name

ALTER SCHEMA

name

OWNER TO {

new\_owner

\| CURRENT\_ROLE \| CURRENT\_USER \| SESSION\_USER }

Description
===========

`ALTER SCHEMA` changes the definition of a schema.

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 also be a direct or indirect member of the new owning
role, and you 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
=============

There is no `ALTER SCHEMA` statement in the SQL standard.

See Also
========
