Beginning Databases with PostgreSQL: From Novice to Professional, 2nd Edition

• The most updated PostgreSQL book on the market, covering version 8.0
• Highlights the most popular PostgreSQL APIs, including C, Perl, PHP, and Java
• This is two books in one; it simultaneously covers key relational database design principles, while teaching PostgreSQL

Table of Contents

Chapter 1 Introduction to PostgreSQL
Chapter 2 Relational Database Principles
Chapter 3 Getting Started with PostgreSQL
Chapter 4 Accessing Your Data
Chapter 5 PostgreSQL Command-Line and Graphical Tools
Chapter 6 Data Interfacing
Chapter 7 Advanced Data Selection
Chapter 8 Data Definition and Manipulation
Chapter 9 Transactions and Locking
Chapter 10 Functions, Stored Procedures, and Triggers
Chapter 11 PostgreSQL Administration
Chapter 12 Database Design
Chapter 13 Accessing PostgreSQL from C Using libpq
Chapter 14 Accessing PostgreSQL from C Using Embedded SQL
Chapter 15 Accessing PostgreSQL from PHP
Chapter 16 Accessing PostgreSQL from Perl
Chapter 17 Accessing PostgreSQL from Java
Chapter 18 Accessing PostgreSQL from C#
Appendix A PostgreSQL Database Limits
Appendix B PostgreSQL Data Types
Appendix C PostgreSQL SQL Syntax Reference
Appendix D psql Reference
Appendix E Database Schema and Tables
Appendix F Large Objects Support in PostgreSQL