CALL ​

Execute a stored procedure.

CALL procedure( [ argvalue [, ...] ] )

For example, call a procedure that has no arguments:

premdb=# call proc1();
CALL

The empty parentheses are required.

If the procedure was created with arguments, call the procedure with appropriate values for those arguments. For example, the procedure addteam has one VARCHAR argument:

premdb=# call addteam('Brighton');
CALL

If the procedure was created with arguments that have default values, you can call the procedure with empty parentheses. The default values will be used.

See also CREATE PROCEDURE.

Parent topic:SQL Commands