- 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
This chapter is intended as a supplement to the PostgreSQL Administrator's Guide, not as a replacement. I've tried to cover the basic operations that a PostgreSQL administrator will be required to perform, but you may need to refer to the official PostgreSQL documentation for detailed reference material.
The next chapter covers the internationalization and localization features of PostgreSQL.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.