Stored Procedure

Core Database

A named block of procedural code stored in the database and executed via CALL. Unlike functions, stored procedures can manage transactions (commit/rollback within the procedure body). Introduced in PostgreSQL 11.