PostgreSQL is one of the world's most popular open source relational database systems. It is renowned for its wide range of capabilities and its ability to perform functions not available in other databases. This book will provide you with the tools to transition into PostgreSQL for the first time, and it will introduce you to the product's most prominent features.

You will learn simultaneously about key relational database design and management principles-all to help you effectively manage your data-driven application. Also included is extensive coverage of the most popular PostgreSQL APIs, including PHP, Perl, Java, and C. You will benefit from the generous reference material covering PostgreSQL data types, syntax, the psql client, and large object support.

• Introduction to PostgreSQL
• Relational Database Principles
• Getting Started with PostgreSQL
• Accessing Your Data
• PostgreSQL Command-Line and Graphical Tools
• Data Interfacing
• Advanced Data Selection
• Data Definition and Manipulation
• Transactions and Locking
• Functions, Stored Procedures, and Triggers
• PostgreSQL Administration
• Database Design
• Accessing PostgreSQL from C Using libpq
• Accessing PostgreSQL from C Using Embedded SQL
• Accessing PostgreSQL from PHP
• Accessing PostgreSQL from Perl
• Accessing PostgreSQL from Java
• Accessing PostgreSQL from C#

• A PostgreSQL Database Limits
• B PostgreSQL Data Types
• C PostgreSQL SQL Syntax Reference
• D psql Reference
• E Database Schema and Tables
• F Large Objects Support in PostgreSQL