© 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 Shaik1   and Dinesh Kumar Chemuduru2
Texas, TX, USA
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 ...

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.