| 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 |