Procedural Programming with PostgreSQL PL/pgSQL: Design Complex Database-Centric Applications with PL/pgSQL

© 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_11

11. Dynamic SQL

Baji Shaik¹   and Dinesh Kumar Chemuduru²

(1)

Texas, TX, USA

(2)

Andhra Pradesh, India

 

In the previous chapter, we talked about custom casting in PostgreSQL and how to define our own custom casting functions. We have also discussed the use cases for custom casting and how to create them accordingly. In this chapter, we will cover the core concepts of dynamic SQL within PostgreSQL’s plpgsql environment. We will provide a comprehensive overview of the syntax and its practical implementation. Additionally, we will cover some real-world ...