Provided by: postgresql-client-8.0_8.0.7-2build1_i386 bug

NAME

       ALTER FUNCTION - change the definition of a function

SYNOPSIS

       ALTER FUNCTION name ( [ type [, ...] ] ) RENAME TO newname
       ALTER FUNCTION name ( [ type [, ...] ] ) OWNER TO newowner

DESCRIPTION

       ALTER FUNCTION changes the definition of a function.

PARAMETERS

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

       type   The data type of an argument of the function.

       newname
              The new name of the function.

       newowner
              The new owner of  the  function.   To  change  the  owner  of  a
              function, you must be a superuser.  Note that if the function is
              marked SECURITY DEFINER, it will subsequently execute as the new
              owner.

EXAMPLES

       To rename the function sqrt for type integer to square_root:

       ALTER FUNCTION sqrt(integer) RENAME TO square_root;

       To change the owner of the function sqrt for type integer to joe:

       ALTER FUNCTION sqrt(integer) OWNER TO joe;

COMPATIBILITY

       There  is  an ALTER FUNCTION statement in the SQL standard, but it does
       not provide the option to rename the function or change the owner.

SEE ALSO

       CREATE FUNCTION [create_function(7)], DROP FUNCTION [drop_function(l)]