Syntax

ALTER FUNCTION function( argument_type [, ...] )
    alter_option;

alteroption depends on the operation you want to perform on the function. For all supported clauses, see the sections below.

Clause

SET SCHEMA

ALTER FUNCTION function( argument_type [, ...] )
    SET SCHEMA schema_name;
Parameter or clauseDescription
SET SCHEMAThis clause changes the schema of the function. To change a function’s schema, you must also have CREATE privilege on the new schema.
schema_nameSpecify the schema to which you want to change.
-- Change the schema of the function named "test_func" to a schema named "test_schema"
ALTER FUNCTION test_func(INT) SET SCHEMA test_schema;