Book description
The second edition of the best-selling PostgreSQL has been updated to completely cover new features and capabilities of the 8.0 version of PostgreSQL. You will be lead through the internals of the powerful PostgreSQL open source database chapter, offering an easy-to-read, code-based approach that makes it easy to understand how each feature is implemented, how to best use each feature, and how to get more performance from database applications. This definitive guide to building, programming and administering the powerful PostgreSQL open-source database system will help you harness one of the most widely used open source, enterprise-level database systems.
Table of contents
- 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
Product information
- Title: PostgreSQL, Second Edition
- Author(s):
- Release date: July 2005
- Publisher(s): Sams
- ISBN: 0672327562
You might also like
book
PostgreSQL: Up and Running, 2nd Edition
Thinking of migrating to PostgreSQL? This clear, fast-paced introduction helps you understand and use this open …
book
PostgreSQL
PostgreSQL is the world¿s most advanced open-source database. PostgreSQL is the most comprehensive, in-depth, and easy-to-read …
book
Practical PostgreSQL
Arguably the most capable of all the open source databases, PostgreSQL is an object-relational database management …
book
PostgreSQL 13 Cookbook
Get to grips with building reliable, scalable, and maintainable database solutions for enterprises and production databases …