| | Copyright |
| | About the Author |
| | About the Technical Reviewers |
| | Acknowledgments |
| | Tell Us What You Think |
| | Introduction |
| | | What's Inside? |
| | | Who Is This Book For? |
| | | Who Is This Book Not For? |
| | | Conventions |
|
| | Part I: SQL Reference |
| | | Chapter 1. PostgreSQL SQL Reference |
| | | Table of Commands |
| | | Alphabetical Listing |
|
|
| | Part II: PostgreSQL Specifics |
| | | Chapter 2. PostgreSQL Data Types |
| | | Table of Data Types |
| | | Geometric Data Types |
| | | Logical Data Types |
| | | Network Data Types |
| | | Numeric Data Types |
| | | String Data Types |
| | | Time Data Types |
| | | Other Data Types |
| | | More Data Types |
|
| | | Chapter 3. PostgreSQL Operators |
| | | Geometric Operators |
| | | Logical Operators |
| | | Network Operators |
| | | Numerical Operators |
| | | String Operators |
| | | Time Operators |
|
| | | Chapter 4. PostgreSQL Functions |
| | | Map of Functions Grouped by Category |
| | | Aggregate Functions |
| | | Conversion Functions |
| | | Geometric Functions |
| | | Network Functions |
| | | Numerical Functions |
| | | SQL Functions |
| | | String Functions |
| | | Time Functions |
| | | User Functions |
| | | Other Functions |
|
| | | Chapter 5. Other PostgreSQL Topics |
| | | Arrays in Fields |
| | | Inheritance |
| | | PostgreSQL Indexes |
| | | OIDs |
| | | Multiversion Concurrency Control |
|
|
| | Part III: PostgreSQL Administration |
| | | Chapter 6. User Executable Files |
| | | Alphabetical Listing of Files |
|
| | | Chapter 7. System Executable Files |
| | | Alphabetical Listing of Files |
|
| | | Chapter 8. System Configuration Files and Libraries |
| | | System Configuration Files |
| | | Library Files |
|
| | | Chapter 9. Databases and Log Files |
| | | PostgreSQL Data Directory |
| | | Log Files |
|
| | | Chapter 10. Common Administrative Tasks |
| | | Compiling and Installation |
| | | Creating Users |
| | | Granting User Rights |
| | | Database Maintenance |
| | | Database Backup/Restore |
| | | Performance Tuning |
|
|
| | Part IV: Programming with PostgreSQL |
| | | Chapter 11. Server-Side Programming |
| | | Benefits of Procedural Languages |
| | | Installing Procedural Languages |
| | | PL/pgSQL |
| | | PL/Tcl |
| | | PL/Perl |
|
| | | Chapter 12. Creating Custom Functions |
| | | Creating Custom Functions |
| | | Creating Custom Triggers |
| | | Creating Custom Rules |
|
| | | Chapter 13. Client-Side Programming |
| | | ecpg |
| | | JDBC |
| | | libpq |
| | | libpq++ |
| | | libpgeasy |
| | | ODBC |
| | | Perl |
| | | Python (PyGreSQL) |
| | | PHP |
|
| | | Chapter 14. Advanced PostgreSQL Programming |
| | | Extending Functions |
| | | Extending Types |
| | | Extending Operators |
|
|
| | Part V: Appendices |
| | | Appendix A. Additional Resources |
| | | PostgreSQL versus Other RDBMSs |
| | | Online PostgreSQL Resources |
| | | Books |
|
| | | Appendix B. PostgreSQL Version Information |
| | | Version 7.1.2 (Released May 2001) |
| | | Version 7.1.1 (Released May 2001) |
| | | Version 7.1 (Released April 2001) |
| | | Version 7.0.3 (Released November 2000) |
| | | Version 7.0.2 (Released June 2000) |
| | | Version 7.0 (Released May 2000) |
| | | Version 6.5.2 (Released September 1999) |
| | | Version 6.5.1 (Released July 1999) |
| | | Version 6.5 (Released June 1999) |
| | | Version 6.4.1 (Released December 1999) |
| | | Version 6.4 (Released October 1998) |
| | | Version 6.3 (Released March 1998) |
| | | Version 6.2.1 (Released October 1997) |
| | | Version 6.2 (Released June 1997) |
| | | Version 6.1 (Released June 1997) |
| | | Version Postgre95 .01 (Released May 1995) |
|
|