This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the
current
version, or one of the other supported versions listed above instead.
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.