- publishing free software manuals
Picture of Cover

PostgreSQL 9.0 Reference Manual - Volume 2
Programming Guide

by: The PostgreSQL Global Development Group

Paperback (6"x9"), 478 pages - New release! (now shipping - December 2010)
Retail Price: $19.95 (£14.95 in UK)
ISBN-13: 978-1-906966-06-5

About the Book

This manual is the part of the official reference documentation for the PostgreSQL RDBMS (version 9.0.1). This volume covers the PostgreSQL client and server interfaces to PostgreSQL: the C/C++ interface libpq, the embedded SQL/C compiler ECPG and the server-side languages PL/pgSQL, PL/Tcl, PL/Perl and PL/Python. Each chapter includes reference documentation and examples. In particular, the use of triggers, rules and views is described in detail. The PL/pgSQL chapter also includes a guide to porting Oracle PL/SQL functions to PostgreSQL.

The other volumes of this series are Volume 1A "The SQL Language" (ISBN 978-1-906966-04-1), Volume 1B, the "SQL Command Reference" (ISBN 978-1-906966-05-8), and Volume 3, the "Server Administration Guide" (ISBN 978-1-906966-07-2).

The authors of this manual are the developers of PostgreSQL.

You can examine the contents of the printed book here,

For each copy of this manual sold $1 is donated to the PostgreSQL project.

As of October 2015 the total amount donated is $4,611 from the sale of this and previous editions.

This book is freely redistributable, under the same license as PostgreSQL itself.


You can buy the book online at the following bookstores:

The manual can also be ordered from most physical bookstores using the ISBN number.

Print out the following flyer for detailed bookstore and library ordering information,

If the title is listed as "out-of-stock", please ask the bookstore to place an order with one of the wholesale suppliers given in the flyer.

If you encounter any difficulties in obtaining this book, please send an email to sales@network-theory.co.uk for assistance.

If you are not completely satisfied with your purchase for any reason we will gladly issue a full refund or replacement (details).

Related Titles

Further Information

For questions about this book, please use our email address sales@network-theory.co.uk.

Table of Contents

  1. Publisher's Preface
  2. Client Interfaces
  3. libpq - C Library
  4. Large Objects
  5. ECPG - Embedded SQL in C
  6. The Information Schema
  7. Server Programming
  8. Extending SQL
  9. Triggers
  10. The Rule System
  11. Procedural Languages
  12. PL/pgSQL - SQL Procedural Language
  13. PL/Tcl - Tcl Procedural Language
  14. PL/Perl - Perl Procedural Language
  15. PL/Python - Python Procedural Language
  16. Server Programming Interface
  17. Other books from the publisher
  18. Index

Supplementary Electronic Volumes

Additional volumes available in PDF format only.

Previous Editions