Red Hat Database

Programmer's Guide

ISBN: N/A
Table of Contents
Organization of this Manual
I. Client Interfaces
1. libpq - C Library
Database Connection Functions
Query Execution Functions
Asynchronous Query Processing
Asynchronous Notification
Fast Path Functions
COPY Command
libpq Tracing Functions
libpq Control Functions
Environment Variables
Threading Behavior
Building libpq Programs
Example Programs
Accessing Large Objects from libpq
2. libpq++ - C++ Binding Library
PGConnection
PgDatabase
3. ecpg - Embedded SQL in C
Using ecpg
Embedded SQL
4. pgtcl - TCL Binding Library
Introduction
Loading pgtcl into an Application
pgtcl Command Reference Information
5. libpgeasy - Simplified libpq C Library
Database Connection Functions
Query Execution and Processing Functions
Error Processing Functions
Example libpgeasy Program: pgwordcount.c
6. ODBC Interface
The ODBC Driver
Installing the ODBC Driver
Access Information File
Configuration of Red Hat Database
Developing an Application with ODBC Functions
Compiling and Running the Sample Applications
Code Sample
7. JDBC Interface
Setting up the JDBC Driver
Driver Basics
Queries and Results
Modifying Data and Databases
Using Large Objects
Multi-Threaded / Servlet Environment Issues
Red Hat Database Extensions to the JDBC API
8. The Python Database API
Introduction
Getting Ready to Use the Python Database API with Red Hat Database
Python Database API Version 2.0 Concepts
Sample Application
Python Code Samples
Code: example.py
9. Setting Up a Web Site that Uses PHP
PHP Installation
Sample Application
II. Server Programming
10. Compiled (C) Language Functions
Calling Conventions for C-Language Functions
Base Types in C-Language Functions
Composite Types in C-Language Functions
Writing Code
Compiling and Linking Dynamically-Loaded Functions
Function Overloading
Procedural Language Handlers
Triggers
11. Server Programming Interface (SPI)
Connection Management Functions
Plan Management
Interface Support Functions
Memory Management
Visibility of Data Changes
Examples
12. PL/pgSQL - SQL Procedural Language
Overview
Structure of PL/pgSQL
Declarations
PL/pgSQL Expressions
Basic Statements
Control Structures
Cursors
Errors and Messages
Trigger Procedures
Examples
Porting from Oracle PL/SQL
13. PL/Tcl - Tcl Procedural Language
Overview
Description
14. PL/Perl - Perl Procedural Language
Overview
Building and Installing PL/Perl
Description
Index