Practical PostgreSQL and over 2 million other books are available for Amazon Kindle . Learn more

Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Image not available

Start reading Practical PostgreSQL on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Practical PostgreSQL [Paperback]

Joshua D. Drake , John C. Worsley
3.0 out of 5 stars  See all reviews (5 customer reviews)

Available from these sellers.


Amazon Price New from Used from
Kindle Edition 16.43  
Paperback -- Trade-In Store
Did you know you can use your mobile to trade in your unwanted books for an Gift Card to spend on the things you want? Visit the Books Trade-In Store for more details or check out the Trade-In Amazon Mobile App Guidelines on how to trade in using a smartphone. Learn more.

Book Description

17 Jan 2002 1565928466 978-1565928466 1

Arguably the most capable of all the open source databases, PostgreSQL is an object-relational database management system first developed in 1977 by the University of California at Berkeley. In spite of its long history, this robust database suffers from a lack of easy-to-use documentation. Practical PostgreSQL fills that void with a fast-paced guide to installation, configuration, and usage.

This comprehensive new volume shows you how to compile PostgreSQL from source, create a database, and configure PostgreSQL to accept client-server connections. It also covers the many advanced features, such as transactions, versioning, replication, and referential integrity that enable developers and DBAs to use PostgreSQL for serious business applications. The thorough introduction to PostgreSQL's PL/pgSQL programming language explains how you can use this very useful but under-documented feature to develop stored procedures and triggers. The book includes a complete command reference, and database administrators will appreciate the chapters on user management, database maintenance, and backup & recovery. With Practical PostgreSQL, you will discover quickly why this open source database is such a great open source alternative to proprietary products from Oracle, IBM, and Microsoft. Also included is a CD-ROM with Command Prompt's PostgreSQL Application Server, LXP. The CD covers LXP version 0.8.0 and PostgreSQL version 7.1.3.

Product details

  • Paperback: 640 pages
  • Publisher: O'Reilly Media; 1 edition (17 Jan 2002)
  • Language: English
  • ISBN-10: 1565928466
  • ISBN-13: 978-1565928466
  • Product Dimensions: 23.3 x 18 x 2.9 cm
  • Average Customer Review: 3.0 out of 5 stars  See all reviews (5 customer reviews)
  • Amazon Bestsellers Rank: 112,757 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Author

Discover books, learn about writers, and more.

Product Description


"...provides an excellent introduction to Postgresql for both newbies, and intermediate users...Overall rating: 9/10." -- Daniel C. Hanks, Provo Linux Users Group, 7 Aug, 2002

From the Author

Practical PostgreSQL is not targetted at the "power SQL users" who already know SQL inside and out. Instead, it focuses on users who are new to PostgreSQL, and who have slight to moderate SQL experience. Consequently, advanced programming in languages such as PHP, C, and C++ are not covered in this book. (There are included, however, a short introductory chapter on JDBC, and a chapter on Command Prompt's commercial web language, LXP).

The most consistently reported flaw in the first edition has been the lack of a comprehensive index. While this has been noted for the second edition, internet users may refer to Command Prompt's website for a complete, on-line edition of the book, along with a search-interface to quickly locate topics not found in the Index.

What Other Items Do Customers Buy After Viewing This Item?

Customer Reviews

3.0 out of 5 stars
3.0 out of 5 stars
Most Helpful Customer Reviews
9 of 9 people found the following review helpful
1.0 out of 5 stars Very poor introduction to PostgreSQL 10 Feb 2004
This book provides a very brief introduction to SQL, a rehash of the installation instructions that come with PostgreSQL itself, and an infuriating "advert" for the authors own commercial addon. Anyone interested in learning how to use PostgreSQL would be much better served by purchasing "PostgreSQL: Introduction and Concepts" by Bruce Momjian, or using the excellent documentation that comes with PostgreSQL.
Books published by O'Reilly used to have a reputation for expanding on freely available documentation in an insightful and well edited manner. However, O'Reilly's recent titles have been little better than the insipid "... For Dummies" series.
Comment | 
Was this review helpful to you?
12 of 13 people found the following review helpful
By A Customer
Having skimmed through a number of books on PostgreSQL this one grabbed my attention by being easily the clearest. It teaches how to use PostgreSQL in a logical way and while it is not a database design book, it gives enough information without getting over-technical. While a little familiarity with linux is expected, the book starts with the absolute basics when it comes to SQL by giving a brief but informative history of relational databases before moving on to teach how to use SQL with PostgreSQL.
Advanced sections such as programming PostgreSQL and using triggers etc mean that by the time you finish reading you are at a good intermediate level and can make use of the command reference at the back to look up any additional details that you need.
Comment | 
Was this review helpful to you?
13 of 15 people found the following review helpful
2.0 out of 5 stars pretty useless 29 July 2002
By A Customer
the bulk of the book is filled with trivially simple examples that really recap standard SQL statements and not postgres specific things. the more advanced chapters briefly gloss over the real interesting bits but again with useless simple examples.
the chapter on LXP is a waste of time, it is only of passing interest and belongs on the web not in a book.
the index is also useless, there's no entry for "cursors" or "keys"!?!...
Comment | 
Was this review helpful to you?
2 of 2 people found the following review helpful
By Krieg
Most O'Reilly material I find quite useful and enjoyable. Practical PostgreSQL was a bit of a disappointment, however. I'd advise you to peruse a copy before buying.

Working with the book

In working with the book, the table of contents and index are a bit thin. For me, this led to often having to browse through the pages. That makes the book a bit impractical for reference use.

Little more than basic install, admin and SQL knowledge

The material inside does cover a reasonable amount of knowledge useful in installing PostgreSQL and the basic administrative jobs involved. It also deals with SQL, although I found it to be of a rather basic level that I fear many will outgrow quickly.

A plug for LXP?

The book seems to deal a considerable amount of space to LXP, a commercial product developed by the authors. The chapter describing it is one of the longest in the book. I did not find this very useful and would rather have seen more advanced SQL material.
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
5.0 out of 5 stars Excellent book, just for beginners 25 April 2002
Well, I've been using PostgreSQL for about a month before it was time to buy a book and get to grips with SQL. This book laid out the things I needed to know in an understandable fashion. Though, one needs to start at the start and read the first three chapters before you start picking pages to read. I can say that this book paid for itself by one SQL command I'd never come across before, it saved my bacon :)
I would have like a better index, but you can't ask for eveything.
Comment | 
Was this review helpful to you?
Would you like to see more reviews about this item?
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category