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

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.

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