alter_schema - phpMan

ALTER SCHEMA()                   SQL Commands                   ALTER SCHEMA()



NAME
       ALTER SCHEMA - change the definition of a schema


SYNOPSIS
       ALTER SCHEMA name RENAME TO newname
       ALTER SCHEMA name OWNER TO newowner


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  auto-
       matically.)

PARAMETERS
       name   The name of an existing schema.

       newname
              The  new  name  of  the  schema. The new name cannot begin with pg_, as such
              names are reserved for system schemas.

       newowner
              The new owner of the schema.

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

SEE ALSO
       CREATE SCHEMA [create_schema(7)], DROP SCHEMA [drop_schema(l)]



SQL - Language Statements         2009-03-12                    ALTER SCHEMA()

Generated by $Id: phpMan.php,v 4.54 2007/08/21 09:05:22 chedong Exp $ Author: Che Dong
On Apache/2.2.3 (Red Hat)
Under GNU General Public License
2009-12-24 02:08 @127.0.0.1 CrawledBy CCBot/1.0 (+http://www.commoncrawl.org/bot.html)