Invokes 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.
CALL is invoked in a transaction block, then the called procedure cannot run transaction control statements. Transaction control statements are only allowed if
CALL is invoked in its own transaction.
PL/pgSQL handles output parameters in
CALL commands differently; refer to Calling a Procedure in the PostgreSQL documentation for more information.
CALL conforms to the SQL standard.
Parent topic: SQL Commands