Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.


If you’re thinking about migrating to the PostgreSQL open source database system, this guide provides a concise overview to help you quickly understand and use PostgreSQL’s unique features. Not only will you learn about the enterprise class features in the 9.2 release, you’ll also discover that PostgeSQL is more than just a database system—it’s also an impressive application platform. With numerous examples throughout this book, you’ll learn how to achieve tasks that are difficult or impossible in other databases.

Subscriber Reviews

Average Rating: 3 out of 5 rating Based on 6 Ratings

"Other reviews are from inexperienced developers" - by John Wheeler on 20-JUL-2013
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
Don't let the noobs who reviewed this book prematurely color your opinion-this book is EXCELLENT and pretty much the only modern, decent Postgres book on Safari right now (2013). It does include advanced material, so I could see how people might interpret the title as misleading, but to give a great book like this that's well written and packed full of gems a single star? it's unfortunate because the frustration of people who aren't able to grasp the material might make others overlook this wonderful book.
Report as Inappropriate

"Incomplete" - by Anonymous on 26-FEB-2013
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
The administration chapter indicates that after you initialize your db that you will have a postgres user, which you should login as in order to perform adminstrative tasks.  However, this book NEVER tells you how to initialize your database nor does it tell you just how you should go about logging in as the postgres user.  Totally useless.  If the reset of the topics are this incomplete why bother.  If I have to search the internet or look for another book for this basic information then just what is THIS book for?
Report as Inappropriate

"Fills an important niche but not for novices" - by albertoc on 12-JAN-2013
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
I have been working with PostgreSQL for years and I have longed for a book like this. The literature is filled with MySQL books for all levels but hardly any new books on PostgreSQL.

My main understanding of the language comes mostly from reading the documentation, which is very good but lacks connections, explanations and some important examples. The documentation is excellent for what it is, no more.

"PostgreSQL: Up and Running" is not perfect a perfect book, and it is not for people new to PostgreSQL. What it is good for is to review what is possible in the language, to have a good reference for features found in this language not available elsewhere. I recommend it to anyone that is working at an intermediate level (like me) and wants to improve his/her understanding.

I would not think it would be good for an expert (not a lot of details,and it might have been longer) or a novice (hardly any basic examples). Could it be better? Yes. Is it a much needed book? Yes.

3 1/2 stars for a very worthwhile light-weight intermediate introduction to the language.

Report as Inappropriate

"New feature of postgresql 9.0-9.2" - by Theerasak on 22-JUL-2012
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
This book is not for newbies. It's preview a lot of new feature of PostgreSQL 9.1 and 9.2.
Report as Inappropriate

"Disappointing" - by Anonymous on 17-JUL-2012
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
I started this book expecting that it's for people who are new to PostgreSQL and this book would describe what the database has and how it delivers.
Couple of the examples in the book are not working. It is obvious that the author(s) had copy-pasted it from somewhere and expected them to give this or that result.
The explanations for this or that syntax is either bad or not full, i.e. for a developer not familiar with PostgreSQL those explanations are confusing. Every now and again the author is describing a topic by using a PostgreSQL specific feature which is not introduced already and there is no reference for the reader what that might be.

Also going with terms "indexes are superb" or stuff like that is insulting. Let the reader determine that!

Report as Inappropriate

Table of Contents



The publisher has provided additional content related to this title.


Visit the catalog page for PostgreSQL: Up and Running

  • Catalog Page

Visit the errata page for PostgreSQL: Up and Running

  • Errata