1ALTER ROUTINE(7)         PostgreSQL 12.2 Documentation        ALTER ROUTINE(7)
2
3
4

NAME

6       ALTER_ROUTINE - change the definition of a routine
7

SYNOPSIS

9       ALTER ROUTINE name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ]
10           action [ ... ] [ RESTRICT ]
11       ALTER ROUTINE name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ]
12           RENAME TO new_name
13       ALTER ROUTINE name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ]
14           OWNER TO { new_owner | CURRENT_USER | SESSION_USER }
15       ALTER ROUTINE name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ]
16           SET SCHEMA new_schema
17       ALTER ROUTINE name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ]
18           DEPENDS ON EXTENSION extension_name
19
20       where action is one of:
21
22           IMMUTABLE | STABLE | VOLATILE | [ NOT ] LEAKPROOF
23           [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER
24           PARALLEL { UNSAFE | RESTRICTED | SAFE }
25           COST execution_cost
26           ROWS result_rows
27           SET configuration_parameter { TO | = } { value | DEFAULT }
28           SET configuration_parameter FROM CURRENT
29           RESET configuration_parameter
30           RESET ALL
31

DESCRIPTION

33       ALTER ROUTINE changes the definition of a routine, which can be an
34       aggregate function, a normal function, or a procedure. See under ALTER
35       AGGREGATE (ALTER_AGGREGATE(7)), ALTER FUNCTION (ALTER_FUNCTION(7)), and
36       ALTER PROCEDURE (ALTER_PROCEDURE(7)) for the description of the
37       parameters, more examples, and further details.
38

EXAMPLES

40       To rename the routine foo for type integer to foobar:
41
42           ALTER ROUTINE foo(integer) RENAME TO foobar;
43
44       This command will work independent of whether foo is an aggregate,
45       function, or procedure.
46

COMPATIBILITY

48       This statement is partially compatible with the ALTER ROUTINE statement
49       in the SQL standard. See under ALTER FUNCTION (ALTER_FUNCTION(7)) and
50       ALTER PROCEDURE (ALTER_PROCEDURE(7)) for more details. Allowing routine
51       names to refer to aggregate functions is a PostgreSQL extension.
52

SEE ALSO

54       ALTER AGGREGATE (ALTER_AGGREGATE(7)), ALTER FUNCTION
55       (ALTER_FUNCTION(7)), ALTER PROCEDURE (ALTER_PROCEDURE(7)), DROP ROUTINE
56       (DROP_ROUTINE(7))
57
58       Note that there is no CREATE ROUTINE command.
59
60
61
62PostgreSQL 12.2                      2020                     ALTER ROUTINE(7)
Impressum