Baji Shaik & Dinesh Kumar Chemuduru 
Procedural Programming with PostgreSQL PL/pgSQL [PDF ebook] 
Design Complex Database-Centric Applications with PL/pgSQL

Chapter 1: Introduction to PL/pg SQL. – Chapter 2: PL/pg SQL Variables. – Chapter 3: PL/pg SQL Data Types. –  Chapter 4: Dealing with Strings, Numbers, and Arrays. – Chapter 5: Control Statements. – Chapter 6: Handling Arrays. – Chapter 7: Handling JSON. – Chapter 8: Cursors. – Chapter 9: Custom Operators. – Chapter 10: Custom Casting. – Chapter 11: Dynamic SQL. – Chapter 12: Building Functions and Procedures. – Chapter 13: Returning Values and Parameters. – Chapter 14: Handling Exceptions. – Chapter 15: Triggers. – Chapter 16: Transaction management. – Chapter 17: Aggregators. – Chapter 18: Listen and Notify. –  Chapter: 19: PL/pg SQL Essential Extensions.

Baji Shaik is a Senior Database Consultant with AWS Professional Services. He was introduced to databases in 2011 and over the years have worked with Oracle, Postgre SQL, Postgres Advance Server, Red Shift, and Greenplum. His background spans a wide depth and breadth of expertise and experience in SQL/No SQL database technologies. He is a Database Migration Expert and has developed many successful database solutions addressing challenging business requirements for moving databases from on-premises to Amazon RDS and Aurora Postgre SQL/My SQL and worked on tuning the RDS/Aurora Postgre SQL/My SQL databases to perform up to the mark. He is an author, having written several books on Postgre SQL. A few of his recent works include “Postgre SQL Configuration”, “Beginning Postgre SQL on the Cloud”, and “Postgre SQL Development Essentials“. Furthermore, he has delivered several conferences, and workshop sessions and published many blogs within the AWS blog community.
Dinesh Chemuduru is working as Principal Architect (OSS). He also worked at AWS as a database consultant and he has done many database migrations successfully. He contributed to a few Open Source solutions and built extensions around Postgre SQL. He loves to code in Flutter/Golang/C++ and deploys them into Kubernetes.