Skip to main content

ALTER FUNCTION

The ALTER FUNCTION command modifies the definition of a function. To use this command, you must own the function.

Syntax

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

alter_option 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;

Help us make this doc better!