PostgreSQL: Introduction and Concepts
Published: 2002, Addison Wesley
450 pages Format: HTML
The book assumes no background in databases at all, but takes the reader from their first database query through to the complex queries needed to solve real-world problems. Highlights common pitfalls and offers many useful tips.
This online version of the book has been updated regularly and has additional chapters that will appear in the next print edition.
Practical PostgreSQL
Published: 2002, Oreilly
636 pages Format: HTML
This is a good reference to PostgreSQL. Besides explaining how to install and configure the database server, it
covers advanced features, such as versioning, replication, database maintenance, and backup & recovery, needed in order to use PostgreSQL for serious business applications. There is an introduction to the PL/pgSQL programming language for developing stored procedures and triggers. Also includes a complete command reference.
This free online version includes a function to search inside the book.