Movatterモバイル変換

ALTER CONVERSION

ALTER CONVERSION — change the definition of a conversion

Synopsis

ALTER CONVERSIONname RENAME TOnew_nameALTER CONVERSIONname OWNER TO {new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }ALTER CONVERSIONname SET SCHEMAnew_schema

Description

ALTER CONVERSION changes the definition of a conversion.

You must own the conversion to useALTER CONVERSION. To alter the owner, you must be able toSET ROLE to the new owning role, and that role must haveCREATE privilege on the conversion's schema. (These restrictions enforce that altering the owner doesn't do anything you couldn't do by dropping and recreating the conversion. However, a superuser can alter ownership of any conversion anyway.)

Parameters

Examples

To rename the conversioniso_8859_1_to_utf8 tolatin1_to_unicode:

ALTER CONVERSION iso_8859_1_to_utf8 RENAME TO latin1_to_unicode;

To change the owner of the conversioniso_8859_1_to_utf8 tojoe:

ALTER CONVERSION iso_8859_1_to_utf8 OWNER TO joe;

Compatibility

There is noALTER CONVERSION statement in the SQL standard.

See Also