- 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
Prerequisites
The examples in this chapter assume that you have installed and configured the unixODBC or iODBC driver manager. I'll also assume that you have installed the PostgreSQL ODBC driver and created an ODBC data source.
Most of the examples in this chapter were developed with the GNU C/C++ compiler and GNU make. The final example uses the Qt library described in Chapter 10, “The PostgreSQL C++ APIu2014libpq++.”
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.