Text Size: Normal / Large

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.

Privacy Policy | Project hosted by our server sponsors. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group