alter_schema(7)

alter_schema7

Change the definition of a schema

Usage

ALTER SCHEMA name RENAME TO newname

Overview

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.

From postgresql 7.4.7-6sarge6 in Debian 3.1 (Sarge). Parsed by carta from the page's man source.