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;