ALTER FUNCTION

A DDL command for modifying a function

ALTER FUNCTION is a DDL command for modifying an existing function.

ALTER FUNCTION was added in PostgreSQL 7.4.

Usage

ALTER FUNCTION is used for updating a function's meta-data.

To change the definition of the function itself, use CREATE OR REPLACE FUNCTION.

Change history

Categories

DDL, Functions and procedures, SQL command

See also

CREATE FUNCTION, DROP FUNCTION, ALTER ROUTINE, ALTER PROCEDURE