GNU/Linux man pages
Livre :
Expressions régulières,
Syntaxe et mise en oeuvre :
GNU/Linux |
CentOS 5.4 |
|
 |
alter_schema(7) |
 |
ALTER SCHEMA − change the definition of a schema
ALTER SCHEMA
name RENAME TO newname
ALTER SCHEMA name OWNER TO newowner
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.)
|
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.
There is no ALTER SCHEMA statement in the SQL standard.
CREATE SCHEMA [create_schema(7)], DROP SCHEMA [drop_schema(l)]
|
alter_schema(7) | |