ALTER ROUTINE

ALTER ROUTINE

ALTER ROUTINE

7

SQL - Language Statements

ALTER ROUTINE

change the definition of a routine

ALTER ROUTINE

name

[ ( [ [

argmode

] [

argname

]

argtype

[, ...] ] ) ]

action

[ ... ] [ RESTRICT ] ALTER ROUTINE

name

[ ( [ [

argmode

] [

argname

]

argtype

[, ...] ] ) ] RENAME TO

new_name

ALTER ROUTINE

name

[ ( [ [

argmode

] [

argname

]

argtype

[, ...] ] ) ] OWNER TO {

new_owner

| CURRENT_ROLE | CURRENT_USER | SESSION_USER } ALTER ROUTINE

name

[ ( [ [

argmode

] [

argname

]

argtype

[, ...] ] ) ] SET SCHEMA

new_schema

ALTER ROUTINE

name

[ ( [ [

argmode

] [

argname

]

argtype

[, ...] ] ) ] [ NO ] DEPENDS ON EXTENSION

extension_name

where

action

is one of:

IMMUTABLE | STABLE | VOLATILE [ NOT ] LEAKPROOF [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER PARALLEL { UNSAFE | RESTRICTED | SAFE } COST

execution_cost

ROWS

result_rows

SET

configuration_parameter

{ TO | = } {

value

| DEFAULT } SET

configuration_parameter

FROM CURRENT RESET

configuration_parameter

RESET ALL

Description#

ALTER ROUTINE changes the definition of a routine, which can be an aggregate function, a normal function, or a procedure. See under ???, ???, and ??? for the description of the parameters, more examples, and further details.

Examples#

To rename the routine foo for type integer to foobar:

ALTER ROUTINE foo(integer) RENAME TO foobar;

This command will work independent of whether foo is an aggregate, function, or procedure.

Compatibility#

This statement is partially compatible with the ALTER ROUTINE statement in the SQL standard. See under ??? and ??? for more details. Allowing routine names to refer to aggregate functions is a PostgreSQL extension.

See Also#

Note that there is no CREATE ROUTINE command.