- Copyright
- The Real Value in Free Software
- About the Authors
- Acknowledgments
- We Want to Hear from You!
- Reader Services
- Introduction
- General PostgreSQL Use
- Introduction to PostgreSQL and SQL
- A Sample Database
- Basic Database Terminology
- Prerequisites
- Connecting to a Database
- Creating Tables
- Viewing Table Descriptions
- Adding New Records to a Table
- Installing the Sample Database
- Retrieving Data from the Sample Database
- The CASE Expression
- Aggregates
- Multi-Table Joins
- UPDATE
- DELETE
- A (Very) Short Introduction to Transaction Processing
- Creating New Tables Using CREATE TABLE...AS
- Using VIEW
- Summary
- Working with Data in PostgreSQL
- PostgreSQL SQL Syntax and Use
- Performance
- Introduction to PostgreSQL and SQL
- Programming with PostgreSQL
- Introduction to PostgreSQL Programming
- Extending PostgreSQL
- Extending the PostgreSQL Server with Custom Functions
- Returning Multiple Values from an Extension Function
- The PostgreSQL SRF Interface
- Returning Complete Rows from an Extension Function
- Extending the PostgreSQL Server with Custom Data Types
- Internal and External Forms
- Defining a Simple Data Type in PostgreSQL
- Defining the Data Type in C
- Defining the Input and Output Functions in C
- Defining the Input and Output Functions in PostgreSQL
- Defining the Data Type in PostgreSQL
- Indexing Custom Data Types
- Summary
- PL/pgSQL
- The PostgreSQL C API—libpq
- A Simpler C API—libpgeasy
- The New PostgreSQL C++ API—libpqxx
- 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
- Npgsql: The .NET Data Provider
- Prerequisites
- Preparing Visual Studio
- Understanding the ADO.NET Class Hierarchy
- Creating an Npgsql-enabled VB Project
- Client 1—Connecting to the Server
- Client 2—An Interactive Query Processor
- Client 3—Updating the Database with a DataSet
- Client 4—A More Robust Query Processor
- Client 5—Using a Typed DataSet
- Summary
- Other Useful Programming Tools
- PostgreSQL Administration
Summary
ODBC is a complex API. I have covered only the basics of ODBC programming in this chapter. If you decide to write a client application using ODBC, I strongly recommend that you obtain one (or more) of the books in the “Resources” section that follows. Several of these books are devoted entirely to ODBC programming, whereas this chapter gives a short introduction aimed at writing simple applications against the PostgreSQL ODBC driver.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.