PostgreSQL.2nd.Edition.pdf

(8632 KB) Pobierz
UNREGISTERD VERSION
PostgreSQL: The comprehensive guide to building, programming, and administering PostgreSQL
databases, Second Edition
By Korry Douglas, Susan Douglas
...............................................
Publisher: Sams Publishing
Pub Date: July 26, 2005
ISBN: 0-672-32756-2
Pages: 1032
Table of Contents | Index
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.
PostgreSQL: The comprehensive guide to building, programming, and administering PostgreSQL
databases, Second Edition
By Korry Douglas, Susan Douglas
...............................................
Publisher: Sams Publishing
Pub Date: July 26, 2005
ISBN: 0-672-32756-2
Pages: 1032
Table of Contents | Index
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.
106373205.020.png 106373205.021.png 106373205.022.png 106373205.023.png 106373205.001.png 106373205.002.png 106373205.003.png 106373205.004.png 106373205.005.png 106373205.006.png 106373205.007.png 106373205.008.png
PostgreSQL: The comprehensive guide to building, programming, and administering PostgreSQL
databases, Second Edition
By Korry Douglas, Susan Douglas
...............................................
Publisher: Sams Publishing
Pub Date: July 26, 2005
ISBN: 0-672-32756-2
Pages: 1032
Table of Contents | Index
Copyright
The Real Value in Free Software
About the Authors
Acknowledgments
We Want to Hear from You!
Reader Services
Introduction
PostgreSQL Features
What Versions Does This Book Cover?
What Topics Does This Book Cover?
What's New in the Second Edition?
Part I: General PostgreSQL Use
Chapter 1. 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
Chapter 2. Working with Data in PostgreSQL
106373205.009.png 106373205.010.png 106373205.011.png 106373205.012.png 106373205.013.png
NULL Values
Character Values
Numeric Values
Date/Time Values
Boolean (Logical) Values
Geometric Data Types
Object IDs (OID)
BLOBs
Network Address Data Types
Sequences
Arrays
Column Constraints
Expression Evaluation and Type Conversion
Creating Your Own Data Types
Summary
Chapter 3. PostgreSQL SQL Syntax and Use
PostgreSQL Naming Rules
Creating, Destroying, and Viewing Databases
Creating New Tables
Adding Indexes to a Table
Getting Information About Databases and Tables
Transaction Processing
Summary
Chapter 4. Performance
How PostgreSQL Organizes Data
Gathering Performance Information
Understanding How PostgreSQL Executes a Query
Execution Plans Generated by the Planner
The ARC Buffer Manager
Table Statistics
Performance Tips
Part II: Programming with PostgreSQL
Chapter 5. Introduction to PostgreSQL Programming
Server-Side Programming
Client-Side APIs
General Structure of Client Applications
Choosing an Application Environment
Summary
Chapter 6. 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
106373205.014.png 106373205.015.png
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
Chapter 7. PL/pgSQL
Installing PL/pgSQL
Language Structure
Function Body
Cursors
Triggers
Polymorphic Functions
PL/pgSQL and Security
Summary
Chapter 8. The PostgreSQL C APIlibpq
Prerequisites
Client 1Connecting to the Server
Client 2Adding Error Checking
Client 3Simple ProcessingPQexec() and PQprint()
Client 4An Interactive Query Processor
Summary
Chapter 9. A Simpler C APIlibpgeasy
Prerequisites
Client 1Connecting to the Server
Client 2Adding Error Checking
Client 3Processing Queries
Client 4An Interactive Query Processor
Summary
Chapter 10. The New PostgreSQL C++ APIlibpqxx
Prerequisites
Client 1Connecting to the Server
Client 2Adding Error Checking
Client 3Processing Queries
Client 4Working with transactors
Summary
Chapter 11. Embedding SQL Commands in C Programsecpg
Prerequisites
Client 1Connecting to the Server
Client 2Adding Error Checking
Client 3Processing SQL Commands
Client 4An Interactive Query Processor
Summary
Chapter 12. Using PostgreSQL from an ODBC Client Application
ODBC Architecture Overview
Prerequisites
106373205.016.png 106373205.017.png
Client 1Connecting to the Server
Client 2Adding Error Checking
Client 3Processing Queries
Client 4An Interactive Query Processor
Summary
Resources
Chapter 13. Using PostgreSQL from a Java Client Application
JDBC Architecture Overview
Prerequisites
Client 1Connecting to the Server
Client 2Adding Error Checking
Client 3Processing Queries
Client 4An Interactive Query Processor
Summary
Chapter 14. Using PostgreSQL with Perl
DBI Architecture Overview
Prerequisites
Client 1Connecting to the Server
Client 2Adding Error Checking
Client 3Processing Queries
Client 4An Interactive Query Processor
Summary
Chapter 15. Using PostgreSQL with PHP
PHP Architecture Overview
Prerequisites
Client 1Connecting to the Server
Client 2Adding Error Checking
Client 3Query Processing
Client 4An Interactive Query Processor
Other Features
Summary
Chapter 16. Using PostgreSQL with Tcl and Tcl/Tk
Prerequisites
Client 1Connecting to the Server
Client 2Query Processing
Client 3An Interactive Query Processor
The libpgtcl Large-Object API
Summary
Chapter 17. Using PostgreSQL with Python
Python/PostgreSQL Interface Architecture
Prerequisites
Client 1Connecting to the Server
Client 2Adding Error Checking
Client 3Query Processing
Client 4An Interactive Command Processor
Summary
106373205.018.png 106373205.019.png

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin