- buster 11.9-0+deb10u1
|CALL(7)||PostgreSQL 11.9 Documentation||CALL(7)|
NAME¶CALL - invoke a procedure
CALL name ( [ argument ] [, ...] )
DESCRIPTION¶CALL executes a procedure.
If the procedure has any output parameters, then a result row will be returned, containing the values of those parameters.
NOTES¶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 43.6.3.
COMPATIBILITY¶CALL conforms to the SQL standard.
SEE ALSO¶CREATE PROCEDURE (CREATE_PROCEDURE(7))