This page in other versions: 9.1 / 9.2 / 9.3 / 9.4 / current (9.5)  |  Development versions: devel / 9.6  |  Unsupported versions: 8.0 / 8.1 / 8.2 / 8.3 / 8.4 / 9.0

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.

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.

Privacy Policy | About PostgreSQL
Copyright © 1996-2016 The PostgreSQL Global Development Group