PostgreSQL Developer's Handbook2001
- Main Page
- Table of content
- Copyright
- About the Authors
- Ewald Geschwinde
- Hans-Jurgen Schonig
- 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. PLPGSQL
- Why Use PLpgSQL?
- Enabling a Database with PLpgSQL
- The Structure of PLpgSQL
- Writing Functions
- Using Functions in PLpgSQL
- Writing Triggers
- Oracle s PLSQL and PLpgSQLComparing 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
- CC
- Embedded SQL C Preprocessor (ECPG)
- Perl
- PHP
- Java
- Python
- TcLTK
- ODBC
- Chapter 10. Extended PostgreSQLSoftware 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 DataReal-World Examples
- Working with SQL
- EFEUThe 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 PerlThe 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 gnuplotA Simple Example
- Summary