In the previous chapter, we talked about JSON data and how to use it in PostgreSQL. In this chapter, we will discuss the basics of cursors in PL/pgSQL, their advantages, and how they can be used to optimize database performance. The chapter begins with an overview of cursors and their benefits, followed by a comparison of the response time between executing an SQL query on the SQL interface and using cursors. Next, we will delve into the different ...
© 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_88. Cursors
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.
