- bullseye 13.5-0+deb11u1
|CALL(7)||PostgreSQL 13.5 Documentation||CALL(7)|
CALL - invoke a procedure
CALL name ( [ argument ] [, ...] )
CALL executes a procedure.
If the procedure has any output parameters, then a result row will be returned, containing the values of those parameters.
The user must have EXECUTE privilege on the procedure in order to be allowed to invoke it.
To call a function (not a procedure), use SELECT instead.
If CALL is executed in a transaction block, then the called procedure cannot execute transaction control statements. Transaction control statements are only allowed if CALL is executed in its own transaction.
PL/pgSQL handles output parameters in CALL commands differently; see Section 42.6.3.
CALL conforms to the SQL standard.
CREATE PROCEDURE (CREATE_PROCEDURE(7))