Stored procedures

The following sections describe stored procedures.

Security considerations
Cross-database access to stored procedures
Block quoting support
Stored procedures are defined as a block or body of numerous lines of text. A block-quoting mechanism is provided to help ease the definition of the procedure body and to make the content more readable for debugging and learning.
SQL restrictions within the stored procedure
Within the body of a stored procedure, you can use most SQL commands to do the tasks that relate to database objects.
Using the JSON and JSONB data types inside stored procedures
Learn how to use the JSON and JSONB data types inside stored procedures.

Parent topic: Introduction to stored procedures