PostgreSQL: Introduction and Concepts

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, this book establishes a firm foundation of basic concepts and commands before turning to PostgreSQL's more advanced and innovative capabilities. It leads step-by-step from your first database query through the complex queries needed to solve real-world base problems. The author presents proper query syntax, and then goes beyond mechanics to explore the value and use of these commands in working database applications. 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, http://www. Postagresql.org/docs/awbook.html, contains updates, corrections, and links to other material.