1CALL(7)                  PostgreSQL 12.2 Documentation                 CALL(7)
2
3
4

NAME

6       CALL - invoke a procedure
7

SYNOPSIS

9       CALL name ( [ argument ] [, ...] )
10

DESCRIPTION

12       CALL executes a procedure.
13
14       If the procedure has any output parameters, then a result row will be
15       returned, containing the values of those parameters.
16

PARAMETERS

18       name
19           The name (optionally schema-qualified) of the procedure.
20
21       argument
22           An input argument for the procedure call. See Section 4.3 for the
23           full details on function and procedure call syntax, including use
24           of named parameters.
25

NOTES

27       The user must have EXECUTE privilege on the procedure in order to be
28       allowed to invoke it.
29
30       To call a function (not a procedure), use SELECT instead.
31
32       If CALL is executed in a transaction block, then the called procedure
33       cannot execute transaction control statements. Transaction control
34       statements are only allowed if CALL is executed in its own transaction.
35
36       PL/pgSQL handles output parameters in CALL commands differently; see
37       Section 42.6.3.
38

EXAMPLES

40           CALL do_db_maintenance();
41

COMPATIBILITY

43       CALL conforms to the SQL standard.
44

SEE ALSO

46       CREATE PROCEDURE (CREATE_PROCEDURE(7))
47
48
49
50PostgreSQL 12.2                      2020                              CALL(7)
Impressum