Procedures and functions in PostgreSQL

  • Module
  • 7 Units
Intermediate
Database Administrator
Azure Database for PostgreSQL

PostgreSQL supports stored procedures and functions to make SQL queries reusable. In this module, you learn how to create and run stored procedures and functions.

Learning objectives

After completing this module, you'll be able to:

  • Create a stored procedure in Azure Database for PostgreSQL.

  • Call a stored procedure in Azure Database for PostgreSQL.

  • Create and use a function in Azure Database for PostrgreSQL.

Prerequisites

  • Demonstrate an understanding of relational databases.

  • Demonstrate an understanding of basic SQL.