PostgreSQL Alter Function Examples

Alter postgresql function

Syntax

ALTER FUNCTION function_name 
( [ [ argmode ] [ argname ] argtype [, ...] ] ) 
RENAME TO new_function_name;

ALTER FUNCTION function_name 
( [ [ argmode ] [ argname ] argtype [, ...] ] ) 
OWNER TO new_owner;

ALTER FUNCTION function_name 
( [ [ argmode ] [ argname ] argtype [, ...] ] ) 
SET SCHEMA new_schema;

Example

ALTER FUNCTION set_customers
(p_first_name varchar, p_last_name varchar) 
RENAME TO add_customers;

ALTER FUNCTION set_customers
(p_first_name varchar, p_last_name varchar) 
OWNER TO user_1;

ALTER FUNCTION set_customers
(p_first_name varchar, p_last_name varchar) 
SET SCHEMA test_schema;