alter_routine(7)

ALTER ROUTINE \nname\n [ ( [ [ \nargmode\n ] [ \nargname\n ] \nargtype\n [, ...] ] ) ]
\n
    \naction\n [ ... ] [ RESTRICT ]
ALTER ROUTINE \nname\n [ ( [ [ \nargmode\n ] [ \nargname\n ] \nargtype\n [, ...] ] ) ]
\n
    RENAME TO \nnew_name\n
ALTER ROUTINE \nname\n [ ( [ [ \nargmode\n ] [ \nargname\n ] \nargtype\n [, ...] ] ) ]
\n
    OWNER TO { \nnew_owner\n | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
ALTER ROUTINE \nname\n [ ( [ [ \nargmode\n ] [ \nargname\n ] \nargtype\n [, ...] ] ) ]
\n
    SET SCHEMA \nnew_schema\n
ALTER ROUTINE \nname\n [ ( [ [ \nargmode\n ] [ \nargname\n ] \nargtype\n [, ...] ] ) ]
\n
    [ NO ] DEPENDS ON EXTENSION \nextension_name\n
where \naction\n is one of:
\n
    IMMUTABLE | STABLE | VOLATILE
\n
    [ NOT ] LEAKPROOF
\n
    [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER
\n
    PARALLEL { UNSAFE | RESTRICTED | SAFE }
\n
    COST \nexecution_cost\n
\n
    ROWS \nresult_rows\n
\n
    SET \nconfiguration_parameter\n { TO | = } { \nvalue\n | DEFAULT }
\n
    SET \nconfiguration_parameter\n FROM CURRENT
\n
    RESET \nconfiguration_parameter\n
\n
    RESET ALL

ALTER ROUTINE foo(integer) RENAME TO foobar;