Invokes a procedure.

Synopsis

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.

Parameters

name

The name (optionally schema-qualified) of the procedure.

argument

An input argument for the procedure call.

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 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.

Examples

CALL do_db_maintenance();

Compatibility

CALL conforms to the SQL standard.

See Also

CREATE PROCEDURE

Parent topic: SQL Commands