© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023
B. Shaik, D. K. ChemuduruProcedural Programming with PostgreSQL PL/pgSQLhttps://doi.org/10.1007/978-1-4842-9840-4_2

2. PL/pgSQL Variables

Baji Shaik1   and Dinesh Kumar Chemuduru2
(1)
Texas, TX, USA
(2)
Andhra Pradesh, India
 

In the previous chapter, we talked about what PL/pgSQL is and some use cases where you need it. We also explained the steps to install and the execution flow of PL/pgSQL with a simple diagram. We have discussed some PL/pgSQL anonymous and named code block examples which will help in understanding the basics. In this chapter, we will introduce variables that are used in the PL/pgSQL code. We will provide different types of variables and use ...

Get Procedural Programming with PostgreSQL PL/pgSQL: Design Complex Database-Centric Applications with PL/pgSQL now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.