Supported versions: Current (18) / 17 / 16 / 15 / 14

Development versions: 19 / 20devel

Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0

Historical version. PostgreSQL 8.0 has reached end of support. See the current manual.

ALTER TYPE

Name

ALTER TYPE -- change the definition of a type

ALTER TYPE name OWNER TO new_owner

ALTER TYPE changes the definition of an existing type. The only currently available capability is changing the owner of a type.

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.

To change the owner of the user-defined type email to joe:

ALTER TYPE email OWNER TO joe;

There is no ALTER TYPE statement in the SQL standard.

Read the upstream documentation. For corrections, first check the current manual.