PostgreSQL is a comprehensive, in-depth, and easy-to-read guide to the award-winning, enterprise-level open source database. Written for users, developers, and administrators, the book begins with a thorough overview of SQL*, and then delves into a description of all PostgreSQL data types and a complete explanation of PostgreSQL commands.

The first section of PostgreSQL includes a complete description of the PostgreSQL API for the most popular programming languages. Easy-to-follow exercises illustrate the development of working applications that fully demonstrate the features offered by each API. The book also offers a chapter describing the PL/pgSQL server-side procedural language, teaching the developer how to build triggers, functions, and stored procedures.

The second section of PostgreSQL was written for the PostgreSQL administrator. It describes how to install PostgreSQL on Windows, Linux, and Unix systems from source code or from precompiled installers. The authors have described all the PostgreSQL configuration options (compile-time, startup, and on-the-fly). The chapter on PostgreSQL security describes all the authentication protocols that the administrator can choose from and describes how to secure a database, both internally and externally.

Contents

• Introduction to PostgreSQL and SQL
• Working with Data in PostgreSQL
• PostgreSQL SQL Syntax and Use
• Performance

• Introduction to PostgreSQL Programming
• Extending PostgreSQL
• PL/pgSQL
• The PostgreSQL C API-libpq
• A Simpler C API-hbpgeasy
• The PostgreSQL C++ API-libpq++
• Embedding SQL Commands in
• C Programs-ecpg
• Using PostgreSQL from an ODBC
• Client Application
• Using PostgreSQL from a Java
• Client Application
• Using PostgreSQL with Perl
• Using PostgreSQL with PHP
• Using PostgreSQL with Tcl and Tcl/Tk
• Using PostgreSQL with Python

• Introduction to PostgreSQL Administration
• PostgreSQL Administration
• Internationalization and Localization Security