PostgreSQL Developer's Handbook

Ewald Geschwinde and Hans-Jürgen Schönig are partners in Cybertec Geschwinde & Schönig OEG (www.cybertec.at), a company based in Vienna, Austria that provides commercial PostgreSQL support, training, tuning, and remote administration to international clients. They also offer training through the first PostgreSQL Academy. Their accomplishments include the creation of a popular Webshop using PostgreSQL and the implementation of a massive scientific database containing data on millions of Austrian social insurance recipients. Before founding Cybertec, both Geschwinde and Schönig worked at Synthesis, an Austrian research company focusing on forecasting the Austrian labor market. While there, the worked with Unix systems and automated text production using EFEU, LaTex, and Perl.

Introduction.
I. Postgresql.

 1. About PostgreSQL.
 2. Preparing.
 3. An Introduction to SQL.
 4. PL/PGSQL.
 5. Understanding Transactions.
 6. Database Administration.
 7. Backup and Recovery.
 8. Performance Tuning.
 9. Programming Interfaces.
10. Open Source Software.
II. PRACTICAL POSTGRESQL SOLUTIONS.

11. Importing Data and Working with Binary Data.
12. Generating Multi-dimensional Results.
13. Classification of Data-Real World Examples.
14. Generating Flash with PostgreSQL and PHP.
15. PostgreSQL Regressions Tests.
16. Extending PostgreSQL's Core Features.
17. Date Calculations.
18. Persistent Database Connections with PHP.
19. Using PostgreSQL and Microsoft Software over the Network.
20. Drawing Graphs on UNIX Systems Using gnuplot and PostgreSQL.
Index.