logo
Free, unlimited AI code reviews that run on commit
git-lrc git-lrc GitHub Install Now We'd appreciate a star git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt

ALTER_CONVERSION - change the definition of a conversion

Compatibility

       There is no ALTERCONVERSION statement in the SQL standard.

Description

ALTERCONVERSION changes the definition of a conversion.

       You must own the conversion to use ALTERCONVERSION. To alter the owner, you must be able to SET ROLE to
       the new owning role, and that role must have CREATE 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.)

Examples

       To rename the conversion iso_8859_1_to_utf8 to latin1_to_unicode:

           ALTER CONVERSION iso_8859_1_to_utf8 RENAME TO latin1_to_unicode;

       To change the owner of the conversion iso_8859_1_to_utf8 to joe:

           ALTER CONVERSION iso_8859_1_to_utf8 OWNER TO joe;

Name

       ALTER_CONVERSION - change the definition of a conversion

Parameters

name
           The name (optionally schema-qualified) of an existing conversion.

       new_name
           The new name of the conversion.

       new_owner
           The new owner of the conversion.

       new_schema
           The new schema for the conversion.

See Also

       CREATE CONVERSION (CREATE_CONVERSION(7)), DROP CONVERSION (DROP_CONVERSION(7))

PostgreSQL 17.5                                       2025                                   ALTERCONVERSION(7)

Synopsis

       ALTER CONVERSION name RENAME TO new_name
       ALTER CONVERSION name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
       ALTER CONVERSION name SET SCHEMA new_schema

See Also