Quick onboard
Deployment
Data Modeling
Connecting
Migration
Query
Operations and Maintenance
Common Maintenance
Partition
Backup and Restore
Expansion
Mirroring
Resource Management
Security
Monitoring
Performance Tuning
Troubleshooting
Reference Guide
Tool guide
Data type
Storage Engine
Executor
Stream
DR (Disaster Recovery)
Configuration
Index
Extension
SQL Reference
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.
name The name (optionally schema-qualified) of the procedure. argument An input argument for the procedure call.
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.
CALL do_db_maintenance();CALL conforms to the SQL standard.