September 26, 2024: PostgreSQL 17 Released!
Supported Versions: Current (17) / 16 / 15 / 14 / 13 / 12
Development Versions: devel
Unsupported versions: 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
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.