Resources | Using PostgreSQL from an ODBC Client Application

1. Stinson, Barry. PostgreSQL Essential Reference. New Riders Publishing, 2002.
Chapter 13 provides a brief description of how to install unixODBC and create a PostgreSQL data source.

2. Gulutzan, Peter and Pelzer, Trudy. SQL-99 Complete, Really. R&D Books, 1999.
The ODBC standard is paralleled by the SQL-99 standard. This book provides a complete description of SQL-99. Most of the information in this book applies directly to an ODBC application.

3. Sanders, Roger E. DB2 Universal Database Call Level Interface Developer's Guide. McGraw-Hill, 1999.
The DB2 Call Level Interface is nearly identical to the ODBC API; as in the previous reference, this book translates almost entirely into ODBC.

4. Geiger, Kyle. Inside ODBC. Microsoft Press, 1995.
This book is currently out of print, but if you can find a copy, I highly recommend it. Inside ODBC includes an interesting history of ODBC development within Microsoft and describes how ODBC works from the inside.

Part I: General PostgreSQL Use

Introduction to PostgreSQL and SQL

Working with Data in PostgreSQL

PostgreSQL SQL Syntax and Use

Performance

Part II: Programming with PostgreSQL

Introduction to PostgreSQL Programming

Extending PostgreSQL

PL/pgSQL

The PostgreSQL C APIlibpq

A Simpler C APIlibpgeasy

The New PostgreSQL C++ APIlibpqxx

Embedding SQL Commands in C Programsecpg

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

Npgsql: The .NET Data Provider

Other Useful Programming Tools

Part III: PostgreSQL Administration

Introduction to PostgreSQL Administration

PostgreSQL Administration

Internationalization and Localization

Security

Replicating PostgreSQL Data with Slony

Contributed Modules

Index