|
1878.5.4
by Brian Aker
Update documentation. |
1 |
ALTER SCHEMA
|
2 |
============
|
|
|
1945.3.8
by Marisa Plumb
fixes to some rst markup |
3 |
|
4 |
ALTER SCHEMA changes the definition of a schema. |
|
5 |
||
6 |
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.::
|
|
7 |
||
8 |
ALTER SCHEMA name RENAME TO new_name
|
|
9 |
ALTER SCHEMA name OWNER TO new_owner
|
|
10 |
||
11 |
name |
|
12 |
||
13 |
The name of an existing schema. |
|
14 |
||
15 |
new_name |
|
16 |
||
17 |
The new name of the schema. The new name cannot begin with pg_, as such names are reserved for system schemas. |
|
18 |
||
19 |
new_owner |
|
20 |
||
21 |
The new owner of the schema. |
|
22 |
||
23 |
||
24 |
See Also: |
|
25 |
||
26 |
* CREATE SCHEMA
|
|
27 |
* DROP SCHEMA
|