This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the
current
version, or one of the other supported versions listed above instead.
ALTER
FUNCTION
Name
ALTER FUNCTION -- change the definition of
a function
Synopsis
ALTER FUNCTION name ( [ type [, ...] ] ) RENAME TO newname
Description
ALTER FUNCTION changes the definition
of a function. The only functionality is to rename the
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.
Examples
To rename the function sqrt for type
integer to square_root:
ALTER FUNCTION sqrt(integer) RENAME TO square_root;
Compatibility
There is an ALTER FUNCTION statement
in the SQL standard, but it does not provide the option to rename
the function.