Subscription

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Conferences

Free Learning

You're reading from PostgreSQL 11 Server Side Programming Quick Start Guide Effective database programming and interaction

Product type Paperback

Published in Nov 2018

Publisher

ISBN-13 9781789342222

Length 260 pages

Edition 1st Edition

Languages

SQL

Tools

PostgreSQL

Concepts

Database Programming

Author (1):

Luca Ferrari

View More author details

Table of Contents (12) Chapters

Preface

1. PostgreSQL Server-side Programming FREE CHAPTER

2. Statement Tricks: UPSERTs, RETURNING, and CTEs

3. The PL/pgSQL Language

4. Stored Procedures

5. PL/Perl and PL/Java

6. Triggers

7. Rules and the Query Rewriting System

8. Extensions

9. Inter Process Communication and Background Workers

10. Custom Data Types

11. Other Books You May Enjoy

Leave a review - let other readers know what you think

Summary

Functions and procedures are powerful building blocks that allow the implementation of reusable server side code. Thanks to their properties, it is possible to write programs that can interact with the underlying database and the current transaction.

In the next chapter, we will learn how functions and procedures can be developed using "external" programming languages such as Perl and Java.

The rest of the chapter is locked

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at €18.99/month. Cancel anytime

Authors (1)

Ferrari

Luca Ferrari has been passionate about computer science since the Commodore 64 era, and today holds a master's degree (with honors) and a Ph.D. from the University of Modena and Reggio Emilia. He has written several research papers, technical articles, and book chapters. In 2011, he was named an Adjunct Professor by Nipissing University. An avid Unix user, he is a strong advocate of open source, and in his free time, he collaborates with a few projects. He met PostgreSQL back in release 7.3; he was a founder and former president of the Italian PostgreSQL Community (ITPUG). He also talks regularly at technical conferences and events and delivers professional training.

See other products by Ferrari