---

PostgreSQL Essential Reference

ISBN: 0735711216
EAN: 2147483647

Year: 2001
Pages: 118

Authors: Barry Stinson

BUY ON AMAZON

• Main Page
• Table of content
• 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 BackupRestore
• Performance Tuning
• Part IV: Programming with PostgreSQL
• Chapter 11. Server-Side Programming
• Benefits of Procedural Languages
• Installing Procedural Languages
• PLpgSQL
• PLTcl
• PLPerl
• 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)