ALTER TYPE
Name
ALTER TYPE -- change the definition of a type
Synopsis
ALTER TYPE name OWNER TO new_owner
Description
ALTER TYPE changes the definition of an existing type. The only currently available capability is changing the owner of a type.
Parameters
- name
-
The name (possibly schema-qualified) of an existing type to alter.
- new_owner
-
The user name of the new owner of the type. You must be a superuser to change a type's owner.
Examples
To change the owner of the user-defined type email to joe:
ALTER TYPE email OWNER TO joe;
Compatibility
There is no ALTER TYPE statement in the SQL standard.