Synopsis
ALTER FUNCTION name ( [ type [, ...] ] ) RENAME TO newname
ALTER FUNCTION name ( [ type [, ...] ] ) OWNER TO newowner
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;