![PostgreSQL: Introduction and Concepts / Edition 1](http://prodimage.images-bn.com/pimages/9780201703313_p0_v1_s192x300.jpg)
PostgreSQL: Introduction and Concepts / Edition 1
by Bruce MomjianThe 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/b>… See more details below
Overview
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 manyexamplesall 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.
Product Details
- ISBN-13:
- 9780201703313
- Publisher:
- Pearson Education
- Publication date:
- 12/04/2000
- Pages:
- 496
- Product dimensions:
- 7.37(w) x 9.15(h) x 0.94(d)
Table of Contents
List of Figures | ||
List of Tables | ||
Foreword | ||
Preface | ||
Acknowledgments | ||
1 | History of PostgreSQL | 1 |
2 | Issuing Database Commands | 5 |
3 | Basic SQL Commands | 11 |
4 | Customizing Queries | 23 |
5 | SQL Aggregates | 49 |
6 | Joining Tables | 57 |
7 | Numbering Rows | 79 |
8 | Combining SELECTS | 87 |
9 | Data Types | 107 |
10 | Transactions and Locks | 121 |
11 | Performance | 131 |
12 | Controlling Results | 137 |
13 | Table Management | 141 |
14 | Constraints | 155 |
15 | Importing and Exporting Data | 169 |
16 | Database Query Tools | 177 |
17 | Programming Interfaces | 187 |
18 | Functions and Triggers | 203 |
19 | Extending POSTGRESQL Using C | 219 |
20 | Administration | 223 |
A: Additional Resources | 233 | |
B: Installation | 255 | |
C | POSTGRESQL Nonstandard Features by Chapter | 257 |
D: Reference Manual | 259 | |
Bibliography | 453 | |
Index | 455 |
Customer Reviews
Average Review: