This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the
current
version, or one of the other supported versions listed above instead.
ALTER
SCHEMA
Name
ALTER SCHEMA -- change the definition of a
schema
Synopsis
ALTER SCHEMA name RENAME TO newname
Description
ALTER SCHEMA changes the definition
of a schema. The only functionality is to rename the schema. To
rename a schema you must own the schema and have the privilege
CREATE for the database.
Parameters
- name
-
Name of a schema
- newname
-
The new name of the schema
Compatibility
There is no ALTER SCHEMA statement in
the SQL standard.