Table of Contents

	Table of Contents
	Index

PostgreSQL
By Korry  Douglas, Susan  Douglas
Publisher	: Sams Publishing
Pub Date	: February 13, 2003
ISBN	: 0-7357-1257-3
Pages	: 816
Slots	: 1			Copyright
		About the Authors
		About the Technical Reviewers
		About the Development Editor
		Acknowledgments
		We Want to Hear from You
		Reader Services
		Preface
		Introduction
			PostgreSQL Features
			What Versions Does This Book Cover?
			What Topics Does This Book Cover?
		Part I:   General PostgreSQL Use
			Chapter 1.   Introduction to PostgreSQL and SQL
				A Sample Database
				Basic Database Terminology
				Prerequisites
				Connecting to a Database
				Creating Tables
				Viewing Table Descriptions
				Adding New Records to a Table
				Installing the Sample Database
				Retrieving Data from the Sample Database
				Aggregates
				Multi-Table Joins
				UPDATE
				DELETE
				A (Very) Short Introduction to Transaction Processing
				Creating New Tables Using CREATE TABLE...AS
				Using VIEW
				Summary
			Chapter 2.   Working with Data in PostgreSQL
				NULL Values
				Character Values
				Numeric Values
				Date/Time Values
				Boolean (Logical) Values
				Geometric Data Types
				Object IDs (OID)
				BLOBs
				Network Address Data Types
				Sequences
				Arrays
				Column Constraints
				Expression Evaluation and Type Conversion
				Creating Your Own Data Types
				Summary
			Chapter 3.   PostgreSQL SQL Syntax and Use
				PostgreSQL Naming Rules
				Creating, Destroying, and Viewing Databases
				Creating New Tables
				Adding Indexes to a Table
				Getting Information About Databases and Tables
				Transaction Processing
				Summary
			Chapter 4.   Performance
				How PostgreSQL Organizes Data
				Gathering Performance Information
				Understanding How PostgreSQL Executes a Query
				Table Statistics
				Performance Tips
		Part II:   Programming with PostgreSQL
			Chapter 5.   Introduction to PostgreSQL Programming
				Server-Side Programming
				Client-Side APIs
				General Structure of Client Applications
				Choosing an Application Environment
				Summary
			Chapter 6.   Extending PostgreSQL
				Extending the PostgreSQL Server with Custom Functions
				Returning Multiple Values from an Extension Function
				Extending the PostgreSQL Server with Custom Data Types
				Internal and External Forms
				Defining a Simple Data Type in PostgreSQL
				Defining the Data Type in C
				Defining the Input and Output Functions in C
				Defining the Input and Output Functions in PostgreSQL
				Defining the Data Type in PostgreSQL
				Summary
			Chapter 7.   PL/pgSQL
				Installing PL/pgSQL
				Language Structure
				Function Body
				Cursors
				Triggers
				Summary
			Chapter 8.   The PostgreSQL C API ”libpq
				Prerequisites
				Client 1 ”Connecting to the Server
				Client 2 ”Adding Error Checking
				Client 3 ”Simple Processing ”PQexec() and PQprint()
				Client 4 ”An Interactive Query Processor
				Summary
			Chapter 9.   A Simpler C API ”libpgeasy
				Prerequisites
				Client 1 ”Connecting to the Server
				Client 2 ”Adding Error Checking
				Client 3 ”Processing Queries
				Client 4 ”An Interactive Query Processor
				Summary
			Chapter 10.   The PostgreSQL C++ API ”libpq++
				Prerequisites
				Client 1 ”Connecting to the Server
				Client 2 ”Adding Error Checking
				Client 3 ”Processing Queries
				Client 4 ”An Interactive Query Processor
				Summary
			Chapter 11.   Embedding SQL Commands in C Programs ”ecpg
				Prerequisites
				Client 1 ”Connecting to the Server
				Client 2 ”Adding Error Checking
				Client 3 ”Processing SQL Commands
				Client 4 ”An Interactive Query Processor
				Summary
			Chapter 12.   Using PostgreSQL from an ODBC Client Application
				ODBC Architecture Overview
				Prerequisites
				Client 1 ”Connecting to the Server
				Client 2 ”Adding Error Checking
				Client 3 ”Processing Queries
				Client 4 ”An Interactive Query Processor
				Summary
				Resources
			Chapter 13.   Using PostgreSQL from a Java Client Application
				JDBC Architecture Overview
				Prerequisites
				Client 1 ”Connecting to the Server
				Client 2 ”Adding Error Checking
				Client 3 ”Processing Queries
				Client 4 ”An Interactive Query Processor
				Summary
			Chapter 14.   Using PostgreSQL with Perl
				DBI Architecture Overview
				Prerequisites
				Client 1 ”Connecting to the Server
				Client 2 ”Adding Error Checking
				Client 3 ”Processing Queries
				Client 4 ”An Interactive Query Processor
				Summary
			Chapter 15.   Using PostgreSQL with PHP
				PHP Architecture Overview
				Prerequisites
				Client 1 ”Connecting to the Server
				Client 2 ”Adding Error Checking
				Client 3 ”Query Processing
				Client 4 ”an Interactive Query Processor
				Other Features
				Summary
			Chapter 16.   Using PostgreSQL with Tcl and Tcl/Tk
				Prerequisites
				Client 1 ”Connecting to the Server
				Client 2 ”Query Processing
				Client 3 ”An Interactive Query Processor
				The libpgtcl Large-Object API
				Summary
			Chapter 17.   Using PostgreSQL with Python
				Python/PostgreSQL Interface Architecture
				Prerequisites
				Client 1 ”Connecting to the Server
				Client 2 ”Adding Error Checking
				Client 3 ”Query Processing
				Client 4 ”An Interactive Command Processor
				Summary
		Part III:   PostgreSQL Administration
			Chapter 18.   Introduction to PostgreSQL Administration
				Security
				User Accounts
				Backup and Restore
				Server Startup and Shutdown
				Tuning
				Installing Updates
				Localization
				Summary
			Chapter 19.   PostgreSQL Administration
				Roadmap (Where's All My Stuff?)
				Installing PostgreSQL
				Managing Databases
				Managing User Accounts
				Configuring Your PostgreSQL Runtime Environment
				Arranging for PostgreSQL Startup and Shutdown
				Backing Up and Copying Databases
				Summary
			Chapter 20.   Internationalization and Localization
				Locale Support
				Multibyte Character Sets
				Summary
			Chapter 21.   Security
				Securing the PostgreSQL Data Files
				Securing Network Access
				Securing Tables
				Summary
		Index