Buy Used
+ £2.80 UK delivery
Used: Good | Details
Sold by Brit-Books
Condition: Used: Good
Comment: Simply Brit: We have dispatched from our UK warehouse books of good condition to over 1 million satisfied customers worldwide. We are committed to providing you with a reliable and efficient service at all times.
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

PostgreSQL: Introduction and Concepts Paperback – 4 Dec 2000

2.5 out of 5 stars 2 customer reviews

See all formats and editions Hide other formats and editions
Amazon Price
New from Used from
"Please retry"
£19.45 £0.01
click to open popover

Special Offers and Product Promotions

Enter your mobile number below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
Getting the download link through email is temporarily not available. Please check back later.

  • Apple
  • Android
  • Windows Phone

To get the free app, enter your mobile phone number.

Product details

  • Paperback: 496 pages
  • Publisher: Addison Wesley (4 Dec. 2000)
  • Language: English
  • ISBN-10: 0201703319
  • ISBN-13: 978-0201703313
  • Product Dimensions: 18.5 x 2.5 x 22.9 cm
  • Average Customer Review: 2.5 out of 5 stars  See all reviews (2 customer reviews)
  • Amazon Bestsellers Rank: 933,673 in Books (See Top 100 in Books)
  • See Complete Table of Contents

Product Description

From the Back Cover

The most advanced, feature-rich SQL database server available, the open-source PostgreSQL system has rapidly become a key Internet technology. PostgreSQL: Introduction and Concepts, written by a founding member of the PostgreSQL Global Development Team, provides a much-needed tutorial and real-world guide to understanding and working with this complex yet essential system.

Assuming no previous knowledge of database systems, the book establishes a firm foundation of basic concepts and commands before turning to PostgreSQL's more advanced and innovative capabilities. It leads you step-by-step from your first database query through the complex queries needed to solve real-world database problems. The author not only presents proper query syntax, he goes beyond the mechanics to explore the value and use of these commands in working database applications.

You will read about such important topics as:

  • Basic SQL commands for manipulating and updating a database
  • Customizing queries
  • SQL aggregates
  • Joining tables
  • Combining SELECTs and subqueries
  • Transactions
  • Performance
  • Importing and exporting data
  • Database query tools, including PSQL and PGACCESS
  • PostgreSQL interfaces to C, C++, ODBC, JDBC, Perl, TCL/TK, and more
  • Server-side programming and multi-user control
  • Extending PostgreSQL with C
  • PostgreSQL administration, including backups, troubleshooting, and access configuration
  • Features unique to PostgreSQL

Throughout, the author highlights common pitfalls, offers tips to save you time and trouble, and provides many examples--all garnered from his extensive experience and inside knowledge. In addition, this resource-rich guide provides a copy of the official PostgreSQL reference manual. A companion web site,, will contain updates, corrections, and links to other material.


About the Author

Bruce Momjian is a founding member of the PostgreSQL Global Development Team. He is currently a senior consultant with Wilson Technology Associates in Newtown Square, Pennsylvania, designing and developing relational database applications for some of the largest law firms nationwide.


Customer Reviews

2.5 out of 5 stars
5 star
4 star
3 star
2 star
1 star
See both customer reviews
Share your thoughts with other customers

Top Customer Reviews

Format: Paperback
From my point of view, I really like this book, because I used SQL quite a long time before. And if you don't know how to use PostgreSQL this book helps you to get started. If you don't know anything about SQL and you want to build an application using a SQL database, this book can give you examples how to realise what you want, but it doesn't teach you how to design a good system. A lot of programming interfaces are mentioned, but the examples are short and superficial. Finally I think this book is a very good resource, and very helpfull if you change from other SQL dialects (like MySQL or Oracle) to PostgreSQL.
Comment 11 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
The book seems to be all over the place, you have to read Appendix B and the last chapter before you can start.

Chapter 2, first page.
At this point, the book makes the following assumptions:
You have installed Postgresql ...
.... .... .....
You have a database called test.

If not, see Appendix B"

Appendix B tells you very little, and sends you to chapter 20 (the last chapter in the book)
Comment One person found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Helpful Customer Reviews on (beta) HASH(0x8a9419b4) out of 5 stars 14 reviews
20 of 20 people found the following review helpful
HASH(0x8abde12c) out of 5 stars Great first book on PostgreSQL 20 Nov. 2000
By Amazon Customer - Published on
Format: Paperback
This is the first book I've seen on PostgreSQL. It's been in progress for sometime, and had been available in electronic form. However, the print version is sure to be a gem. It contains information needed by anyone trying to get a handle on PostgreSQL, beginner or advanced. The folks starting to use PostgreSQL will have alot of examples on standard SQL for database access, including transaction support. The more advanced users will appreciate the level of detail including how PostgreSQL differs from standard SQL (Good news is that this isn't by much) and integration with other tools. It also has good information about transaction requirements and ways they are implemented within the context of PostgreSQL, as well as how to increase performance. I gave it four stars out of five only because I thought it could have used more administration details and hints. Though the administration section in the book is still a good read, and it is clearly a topic that can take another book to complete. In short, I highly recommend the book for those wanting to learn more about this open-source database.
18 of 19 people found the following review helpful
HASH(0x8bb587b0) out of 5 stars A great overview of Postgres 16 Jan. 2001
By Mel Beckman - Published on
Format: Paperback Verified Purchase
It's an odd commentary on the open source movement that, while open source code seems sophisticated and reliable -- as a result of the many hands working on it -- open source documentation, as a general rule, sucks. I believe that this book is the _first_ printed book on PostgreSQL. As such, the author is to be commended for his effort at collecting a great deal of useful Postgres info in one place, helping readers find the essential knowledge buried in the sea of online documentation.
The book's title says "Introduction and Concepts", letting you know this isn't an advanced treatise on Postgres. The first half of the book handily summarizes SQL and then dives into hands-on PostgreSQL, run interactively via the psql interactive utility. This is a nice way to give readers direct experience with Postgres, but it is also automatically limiting because readers never learn how to use Postgres in the context of an application. There is a chapter on programming interfaces, but it covers ten languages in ten pages, which isn't enough to impart any practical Postgres programming skills.
The second half of the book is a verbatim replica of the SQL Commands reference from the official Postgres user's guide. It's handy to have in the book, but it's hard to give the author any credit for simply pouring this stuff into his book unchanged. I would have liked to see some useful annotations from the author, reflecting his obviously considerable experience with Postgres.
I gave the book four stars in part because the author is breaking new ground by carving out a niche with publishers for future PostgreSQL books. I'm hoping a second edition of his book comes soon, replacing (or augmenting) those 250 pages of reference material with concrete programming examples in a variety of languages and interesting comments on usage. In the meantime, this book is a very nice primer for our new employees who have to come up to speed on PostgreSQL quickly.
17 of 20 people found the following review helpful
HASH(0x8b659810) out of 5 stars no limits (and that is a bad thing) 17 April 2001
By Philip Greenspun - Published on
Format: Paperback
I teach Software Engineering for Internet Applications. Our students are free to use whatever ACID-compliant RDBMS they prefer. Since PostgreSQL is more or less the only open-source candidate (unless you count the RDBMS open-sourced by SAP), PostgreSQL is our students' third most popular choice (after Oracle and Microsoft SQL Server). The students using this book have a horrible time picking data types because the book doesn't provide fundamental information, or at least none that we could find. Want to know how long a character string can be? How precise a timestamp is? You won't find the answers in this book.
13 of 15 people found the following review helpful
HASH(0x8ad35e1c) out of 5 stars Change the title 12 Jun. 2001
By Amazon Customer - Published on
Format: Paperback
First of all, this is not a book about Postgresql database, it's a book about introduction to SQL!
Considering the title, it should at least give some direction about how to install/configure, list the gotcha's, do's, don't's, etc. But this book starts with the assumption that you already have the database installed and ready to run, server and all.
I'm not kidding, it's actually listed in one of the first sections in the book that a running server is required to read this book. How does this match the "Introduction and Concepts" title???
A little pointer to the author if he's reading this, in his next book or second edition of this book, he should: 1. Explain where PostgreSQL fits in modern distributed architectures 2. Why would I want to use PostgreSQL instead of MySQL if I'm developing a J2EE application, how about CORBA? 3. How do I take advantage of the OO features of PostgreSQL to shorten the development time
8 of 9 people found the following review helpful
HASH(0x8ae51abc) out of 5 stars A very good reference 14 Feb. 2001
By Dann Corbit - Published on
Format: Paperback
This book is a very good reference work. I expect the major usefulness will be to for programmers (both C programmers making modifications to the source and also for SQL programmers). Another reviewer said it was mostly a padding of the FAQ (which is 8 pages, developer FAQ + 18 pages for the general FAQ) whereas the book is well over 400 pages. I don't really see any sort of connection there. Suggested improvements: Add a long section on installation. The book does not mention running the regression tests. The regression tests can be difficult to configure, and this is especially so under Cygwin on NT or Win2K. Also, maintenance operations and bulk copy operations should be much, much larger with copious examples.
If you plan to program in PostgreSQL or modify the PostgreSQL program, you must buy this book. Also highly recommended is the somewhat obscure paper: "Enhacement of the ANSI SQL Implementation of PostgreSQL" by Gottlob & Seyr.
PostgreSQL is the ONLY fully functional SQL implementation with a TRULY open license. I hope to see more fine efforts like this in the future.
Were these reviews helpful? Let us know