Featured resource
pluralsight tech forecast
2025 Tech Forecast

Which technologies will dominate in 2025? And what skills do you need to keep up?

Check it out
Hamburger Icon
  • Course
    • Libraries: If you want this course, consider one of these libraries.
    • Data

Capturing Logic with Custom Functions in PostgreSQL

Whether you are getting into PostgreSQL for the first time or an experienced developer wanting to explore function-writing more deeply, this course is for you. You will learn foundational knowledge of how to build your own functions in PostgreSQL.

Gerald Britton - Pluralsight course - Capturing Logic with Custom Functions in PostgreSQL
by Gerald Britton

What you'll learn

At the core of a PostgresSQL database developer's toolkit is a thorough knowledge of how to build correct, efficient functions. In this course, Capturing Logic with Custom Functions in PostgreSQL, you will learn foundational knowledge of how to build your own functions in PostgreSQL. First, you will learn how to move from a basic query to a fully-parameterized function. Next, you will discover how to write your functions using PL/pgSQL, one of the many procedural languages available to the PostgreSQL developer. Finally, you will explore important matters relating to polymorphism, security, defensive programming and error handling. When you are finished, you will be able to solve real-world problems using PostgresSQL functions.

Table of contents

About the author

Gerald Britton - Pluralsight course - Capturing Logic with Custom Functions in PostgreSQL
Gerald Britton

Gerald is a multiple-year of the Microsoft MVP award, Gerald has led introductory classes in Python and SQL for industry-sponsored events at Ryerson University, Toronto and the University of Toronto (his alma mater). 

More Courses by Gerald