I l@ve RuBoard

•	Table of Contents

PostgreSQL Essential Reference
By Barry Stinson
Publisher	: New Riders Publishing
Pub Date	: October 19, 2001
ISBN	: 0-7357-1121-6
Pages	: 400

		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)

I l@ve RuBoard