PostgreSQL

PostgreSQL
By Korry Douglas, Susan Douglas

Publisher : Sams Publishing
Pub Date : February 13, 2003
ISBN : 0-7357-1257-3
Pages : 816
Slots : 1


The definitive guide to working with the powerful PostgreSQL open source database system.

PostgreSQL leads the reader through the internals of the powerful PostgreSQL open source database. Throughout the book, readers will find explanations of data structures and algorithms, each backed by a concrete example from the actual source code. Each section contains information about performance implications, debugging techniques, and pointers to more information (on Web and in book form). The reader will find an easy to read, code-based approach that makes it easy to understand how each feature is implemented, how to best use each feature, and how to squeeze more performance from database applications. Previously announced in 2/03 catalog. Korry Douglas is the Director of Research and Development for Appx Software. Over the last two decades, he has worked on the design and implementation of a number of high-level languages and development environments. His products interface with many relational (and non-relational) databases. Working with many different database products (Oracle, Sybase, SQL Server, PostgreSQL, MySQL, and MSQL) has given him a unique understanding of the commonalties of, and differences between databases.

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

Download
Another Database books