ALTER CONVERSION

ALTER CONVERSION

Changes the definition of a conversion.

Synopsis

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

Description

ALTER CONVERSION changes the definition of a conversion.

You must own the conversion to use ALTER CONVERSION.
To alter the owner, you must also be a direct or indirect member of the
new owning role, and that role must have CREATE privilege
on the conversion's schema. (These restrictions enforce that altering
the owner does not do anything you could not do by dropping and recreating
the conversion. However, a superuser can alter ownership of any conversion
anyway.)