|
Practical PostreSQL
Arguably the most capable of all the open source databases,
PostgreSQL is an object-relational database management
system first developed in 1977 by the University of
California at Berkeley. In spite of its long history, this
robust database suffers from a lack of easy-to-use
documentation. Practical PostgreSQL fills that
void with a
fast-paced guide to installation, configuration, and usage.
This comprehensive new volume shows you how to compile
PostgreSQL from source, create a database, and configure
PostgreSQL to accept client-server connections. It also
covers the many advanced features, such as transactions,
versioning, replication, and referential integrity that
enable developers and DBAs to use PostgreSQL for serious
business applications. The thorough introduction to
PostgreSQL's PL/pgSQL programming language explains how you
can use this very useful but under-documented feature to
develop stored procedures and triggers. The book includes a
complete command reference, and database administrators
will appreciate the chapters on user management, database
maintenance, and backup & recovery. With Practical
PostgreSQL, you will discover quickly why this open source
database is such a great open source alternative to
proprietary products from Oracle, IBM, and Microsoft.
Also included is a CD-ROM with Command Prompt's PostgreSQL
Application
Server, LXP. The CD covers LXP version 0.8.0 and PostgreSQL
version 7.1.3.
Preface
PART 1: Introduction & Installation
Chapter 1. What Is PostgreSQL?
Open Source Free Version
PostgreSQL Feature Set
Where to Proceed from Here
Chapter 2. Installing PostgreSQL
Preparing for Installation
10 Steps to Installing PostgreSQL
PART 2: Using PostgreSQL
Chapter 3. Understanding SQL
Introduction to SQL
Introduction to Relational Databases
SQL Statements
Data Types
Tables in PostgreSQL
Chapter 4. Using SQL with PostgreSQL
Introduction to psql
Using Tables
Adding Data with INSERT and COPY
Retrieving Rows with SELECT
Modifying Rows with UPDATE
Removing Rows with DELETE
Using Sub-Queries
Using Views
Further SQL Application
Chapter 5. Operators and Functions
Operators
Functions
Chapter 6. PostgreSQL Clients
The psql Client: Advanced Topics
PgAccess: A Graphical Client
Chapter 7. Advanced Features
Indices
Advanced Table Techniques
Arrays
Automating Common Routines
Transactions and Cursors
Extending PostgreSQL
PART 3: Administrating PostgreSQL
Chapter 8. Authentication and Encryption
Client Authentication
Encrypting Sessions
Chapter 9. Database Management
Starting and Stopping PostgreSQL
Initializing the Filesystem
Creating and Removing a Database
Maintaining a Database
Backing Up and Restoring Data
Chapter 10. User and Group Management
Managing Users
Managing Groups
Granting Privileges
PART 4: PostgreSQL Programming
Chapter 11. PL/pgSQL
Adding PL/pgSQL to Your Database
Language Structure
Using Variables
Controlling Program Flow
PL/pgSQL and Triggers
Chapter 12. JDBC
Building the PostgreSQL JDBC Driver
Using the PostgreSQL Driver
Using JDBC
Issues Specific to PostgreSQL and JDBC
Chapter 13. LXP
Why Use LXP?
Core Features
Installing and Configuring LXP
Understanding LXP Mark-Up
LXP Variables and Objects
Using Cookies with LXP
Tag Parsing
Branching Logic
Loop Iteration
Content Inclusion
Displaying Foreign Tags with <xtag>
PART 5: Command Reference
Chapter 14. PostgreSQL Command Reference
Appendix A. Multibyte Encoding Types
Appendix B. Backend Options for postgres
Appendix C. Binary COPY Format
Appendix D. Internal psql Variables
Index
|
