Table of content

	Table of Contents
	Index

PostgreSQL Developer's Handbook
By Ewald  Geschwinde, Hans-J ¼rgen  Sch nig
Publisher	: Sams Publishing
Pub Date	: December 18, 2001
ISBN	: 0-672-32260-9
Pages	: 768
	Copyright
		About the Authors
			Ewald Geschwinde
			Hans-J ¼rgen Sch nig
		Acknowledgments
		Tell Us What You Think!
		Introduction
		Part  I.   PostgreSQL
			Chapter  1.   About PostgreSQL
				License
				The Basic Concepts of PostgreSQL
			Chapter  2.   Preparing
				Hardware Requirements
				Software Requirements
				Installing PostgreSQL
				Starting the Server and Creating Databases
				The User Interface
			Chapter  3.   An Introduction to SQL
				Relational Databases and Their Components
				Building a Database
				Inserting Data
				Retrieving Data
				Updating and Deleting Data
				Writing Advanced SQL Code
				Building Complex Data Structures and Modeling Techniques
			Chapter  4.   Understanding Transactions
				How the Transaction Code Affects Daily Work
			Chapter  5.   PL/PGSQL
				Why Use PL/pgSQL?
				Enabling a Database with PL/pgSQL
				The Structure of PL/pgSQL
				Writing Functions
				Using Functions in PL/pgSQL
				Writing Triggers
				Oracle's PL/SQL and PL/pgSQL ”Comparing Two Worlds
			Chapter  6.   Database Administration
				How to Configure PostgreSQL
				Adding Users and Managing User Rights
				Modifying Databases
				System Tables
				Security and Access Restrictions
				Summary
			Chapter  7.   Backup and Recovery
				Common Errors
				Backup Strategies and Tools for PostgreSQL
				Summary
			Chapter  8.   Performance Tuning
				Measuring Performance
				Indexes and Performance
				Using EXPLAIN and Understanding the Optimizer
				Tuning SQL
				System Performance
				Working with Large Amounts of Data
				Regular Expressions and Performance
				Summary
			Chapter  9.   Programming Interfaces
				C/C++
				Embedded SQL C Preprocessor (ECPG)
				Perl
				PHP
				Java
				Python
				TcL/TK
				ODBC
			Chapter  10.   Extended PostgreSQL ”Software for PostgreSQL
				Contributed Software
				Administration Tools
		Part  II.   Practical PostgreSQL Solutions
			Chapter  11.   Importing Data and Working with Binary Data
				Importing ASCII and Binary Data Using COPY
				Working with ASCII and EBCDIC
				Summary
			Chapter  12.   Generating Multidimensional Results
				Generating Multidimensional Results on the Database Level
				Creating Multidimensional Arrays on the Application Level
				Summary
			Chapter  13.   Classification of Data ”Real-World Examples
				Working with SQL
				EFEU ”The Perfect Tool for Data Warehousing
				Summary
			Chapter  14.   Generating Flash with PostgreSQL and PHP
				PHP's Flash Interfaces
				Simple Flash Examples
				Adding Data to Flash
				Working with Geometric Datatypes
				Using Action Script for Interactive Applications
				A Final Example
				Summary
			Chapter  15.   PostgreSQL Regression Tests
				The Idea Behind Regression Tests
				Running Tests
				Evaluating Regression Tests
				Summary
			Chapter  16.   Extending PostgreSQL's Core Features
				Adding Functions and an Overview of Programming Conventions
				Adding Datatypes
				Adding Operators
				Adding Aggregates
				Changing PostgreSQL's Rule System
				Summary
			Chapter  17.   Date Calculations
				SQL and Dates
				Using Perl ”The DateCalc Module
				Analyzing a Time Series
				Summary
			Chapter  18.   Persistent Database Connections with PHP
				Speed Tests
				Dangerous Side Effects
				Testing Persistent Connections
				Summary
			Chapter  19.   Using PostgreSQL and Microsoft Software over the Network
				Connecting to MS Office
				Using Visual Basic to Connect to PostgreSQL
				Using PostgreSQL with Microsoft Office
				Summary
			Chapter  20.   Drawing Graphs on Unix Systems Using gnuplot and PostgreSQL
				About gnuplot
				Using PostgreSQL and gnuplot
				A Simple LaTex Document
				Geometric Datatypes and gnuplot ”A Simple Example
				Summary
		Index