- 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
If you want to try out the examples in this chapter, you will need to install and configure the following components (in addition to a running PostgreSQL installation):
Perl5 or later (www.perl.org)
The DBI module (www.cpan.org/modules/by-module/DBI)
The DBD::Pg driver (www.cpan.org/modules/by-module/DBD)
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.