Index for Section FUNCTION

Alphabetical listing for A

Bottom of page

ALTER
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(5)], DROP FUNCTION [drop_function(l)]

Index for Section FUNCTION

Alphabetical listing for A

Top of page