Difficulty Level
Intermediate
Completion Time
10h40m
Language
English
About Book
Who Is This Book For?
This book is for moderate to advanced PostgreSQL database professionals who wish to extend PostgreSQL, utilizing the most updated features of PostgreSQL 9.4. For a better understanding of this book, familiarity with writing SQL, a basic idea of query tuning, and some coding experience in your preferred language is expected.
PostgreSQL Server Programming
- About Book
- Who Is This Book For?
- Book Content
Book content
chapters • 10h40m total length
Why 'program in the server'?
Introduction to PostgreSQL server programming fundamentals
Writing Your First PL/PgSQL Function
Advanced PL/PgSQL - Creating Set Returning and Table Functions, Using Cursors
Defining and Using PL/PgSQL TRIGGER functions
Writing PostgreSQL Event Trigger Functions
Debugging PL/PgSQL
Using unrestricted language - PL/pythonu
Writing Z Functions in C
Scaling Your Database with pl/proxy
PL/Perl - Perl Procedural Language
PL/Tcl - Tcl Procedural Language
Publishing Your Code as Extensions
Learning More About PostgreSQL as Extensible RDBMS
Related Resources
Access Ready-to-Use Books for Free!
Get instant access to a library of pre-built books—free trial, no credit card required. Start training your team in minutes!