Text Size: Normal / Large

PostgreSQL 8.0.17 Documentation
Prev	Fast Backward		Fast Forward	Next

ALTER CONVERSION

Name

ALTER CONVERSION -- change the definition of a conversion

ALTER CONVERSION name RENAME TO newname
ALTER CONVERSION name OWNER TO newowner

ALTER CONVERSION changes the definition of a conversion.

name: The name (optionally schema-qualified) of an existing conversion.
newname: The new name of the conversion.
newowner: The new owner of the conversion. To change the owner of a conversion, you must be a superuser.

To rename the conversion iso_8859_1_to_utf_8 to latin1_to_unicode:

ALTER CONVERSION iso_8859_1_to_utf_8 RENAME TO latin1_to_unicode;

To change the owner of the conversion iso_8859_1_to_utf_8 to joe:

ALTER CONVERSION iso_8859_1_to_utf_8 OWNER TO joe;

There is no ALTER CONVERSION statement in the SQL standard.

No comments could be found for this page.

New comments cannot be added to old documentation versions.