Home > Store

PostgreSQL Developer's Handbook

Register your product to gain access to bonus material or receive a coupon.

PostgreSQL Developer's Handbook

Premium Website

  • Sorry, this book is no longer in print.
Not for Sale


  • Copyright 2002
  • Edition: 1st
  • Premium Website
  • ISBN-10: 0-672-32260-9
  • ISBN-13: 978-0-672-32260-0

PostgreSQL is an object-relational database server that is widely considered to be the world¿s most advanced open-source database system. It is ANSI SQL-compatible, and it offers powerful features to enable more complex software design than would be possible with relational databases that are not object-oriented. PostgreSQL is extremely modular, it supports a large number of datatypes, and programming interfaces for PostgreSQL are available for all important programming languages, including C, Perl, Python, Tcl, Java, and PHP.

PostgreSQL Developer¿s Handbook provides a complete overview of the PostgreSQL database server and extensive coverage of its core features, including object orientation, PL/pgSQL, and the most important programming interfaces. The book introduces the reader to the language and syntax of PostgreSQL and then moves quickly into advanced programming topics.

Sample Content

Online Sample Chapters

An Introduction to SQL

Handling Geometric Data with PostgreSQL

Multidimensional Data Cubes with EFEU and PostgreSQL

Working with Views in PostgreSQL

Table of Contents


I. Postgresql.

 1. About PostgreSQL.
 2. Preparing.
 3. An Introduction to SQL.
 5. Understanding Transactions.
 6. Database Administration.
 7. Backup and Recovery.
 8. Performance Tuning.
 9. Programming Interfaces.
10. Open Source Software.


11. Importing Data and Working with Binary Data.
12. Generating Multi-dimensional Results.
13. Classification of Data-Real World Examples.
14. Generating Flash with PostgreSQL and PHP.
15. PostgreSQL Regressions Tests.
16. Extending PostgreSQL's Core Features.
17. Date Calculations.
18. Persistent Database Connections with PHP.
19. Using PostgreSQL and Microsoft Software over the Network.
20. Drawing Graphs on UNIX Systems Using gnuplot and PostgreSQL.


Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership