ALTER DATABASE
Use ALTER DATABASE to:
- Rename a database.
- Change owner of a database.
Syntax
Rename
To rename a database:
ALTER DATABASE <name> RENAME TO <new_name>;
| Syntax element | Description |
|---|---|
<name> |
The current name of the database. |
<new_name> |
The new name of the database. |
See also Renaming restrictions.
Change owner
To change the owner of a database:
ALTER DATABASE <name> OWNER TO <new_owner_role>;
| Syntax element | Description |
|---|---|
<name> |
The name of the database you want to change ownership of. |
<new_owner_role> |
The new owner of the database. |
To change the owner of a database, you must be the current owner and have
membership in the <new_owner_role>.
Privileges
The privileges required to execute this statement are:
- Ownership of the database.
- In addition, to change owners:
- Role membership in
new_owner.
- Role membership in