Contents
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
- PostgreSQL 12
- option
SUPPORTadded (commit 1fb57af9)
- option
- PostgreSQL 9.6
- PostgreSQL 8.3
- PostgreSQL 8.1
- PostgreSQL 8.0
ALTER FUNCTION ... OWNER TO ...syntax added (commit 0adfa2c3)
- PostgreSQL 7.4
- added (commit b256f242)
References
- PostgreSQL documentation: ALTER FUNCTION