PostgreSQL (2nd Edition)
PostgreSQL (2nd Edition)
ISBN: 0672327562
EAN: 2147483647
EAN: 2147483647
Year: 2005
Pages: 220
Pages: 220
Authors: Korry Douglas
- PostgreSQL
- Table of Contents
- Copyright
- About the Authors
- About the Technical Reviewers
- About the Development Editor
- Acknowledgments
- We Want to Hear from You
- Reader Services
- Preface
- Introduction
- PostgreSQL Features
- What Versions Does This Book Cover?
- What Topics Does This Book Cover?
- 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
- 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
- NULL Values
- Character Values
- Numeric Values
- DateTime 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
- 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
- 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
- Summary
- Chapter 7. PLpgSQL
- Installing PLpgSQL
- Language Structure
- Function Body
- Cursors
- Triggers
- Summary
- Chapter 8. The PostgreSQL C API - libpq
- Prerequisites
- Client 1 - Connecting to the Server
- Client 2 - Adding Error Checking
- Client 3 - Simple Processing - PQexec() and PQprint()
- Client 4 - An Interactive Query Processor
- Summary
- Chapter 9. A Simpler C API - libpgeasy
- Prerequisites
- Client 1 - Connecting to the Server
- Client 2 - Adding Error Checking
- Client 3 - Processing Queries
- Client 4 - An Interactive Query Processor
- Summary
- Chapter 10. The PostgreSQL C API - libpq
- Prerequisites
- Client 1 - Connecting to the Server
- Client 2 - Adding Error Checking
- Client 3 - Processing Queries
- Client 4 - An Interactive Query Processor
- Summary
- Chapter 11. Embedding SQL Commands in C Programs - ecpg
- Prerequisites
- Client 1 - Connecting to the Server
- Client 2 - Adding Error Checking
- Client 3 - Processing SQL Commands
- Client 4 - An Interactive Query Processor
- Summary
- Chapter 12. Using PostgreSQL from an ODBC Client Application
- ODBC Architecture Overview
- Prerequisites
- Client 1 - Connecting to the Server
- Client 2 - Adding Error Checking
- Client 3 - Processing Queries
- Client 4 - An Interactive Query Processor
- Summary
- Resources
- Chapter 13. Using PostgreSQL from a Java Client Application
- JDBC Architecture Overview
- Prerequisites
- Client 1 - Connecting to the Server
- Client 2 - Adding Error Checking
- Client 3 - Processing Queries
- Client 4 - An Interactive Query Processor
- Summary
- Chapter 14. Using PostgreSQL with Perl
- DBI Architecture Overview
- Prerequisites
- Client 1 - Connecting to the Server
- Client 2 - Adding Error Checking
- Client 3 - Processing Queries
- Client 4 - An Interactive Query Processor
- Summary
- Chapter 15. Using PostgreSQL with PHP
- PHP Architecture Overview
- Prerequisites
- Client 1 - Connecting to the Server
- Client 2 - Adding Error Checking
- Client 3 - Processing Queries
- Client 4 - An Interactive Query Processor
- Other Features
- Summary
- Chapter 16. Using PostgreSQL with Tcl and TclTk
- Prerequisites
- Client 1 - Connecting to the Server
- Client 2 - Query Processing
- Client 4 - An Interactive Query Processor
- The libpgtcl Large-Object API
- Summary
- Chapter 17. Using PostgreSQL with Python
- PythonPostgreSQL Interface Architecture
- Prerequisites
- Client 1 - Connecting to the Server
- Client 2 - Adding Error Checking
- Client 3 - Query Processing
- Client 4 - An Interactive Command Processor
- Summary
- Part III: PostgreSQL Administration
- Chapter 18. Introduction to PostgreSQL Administration
- Security
- User Accounts
- Backup and Restore
- Server Startup and Shutdown
- Tuning
- Installing Updates
- Localization
- Summary
- Chapter 19. PostgreSQL Administration
- Roadmap (Where s All My Stuff?)
- Installing PostgreSQL
- Managing Databases
- Managing User Accounts
- Configuring Your PostgreSQL Runtime Environment
- Arranging for PostgreSQL Startup and Shutdown
- Backing Up and Copying Databases
- Summary
- Chapter 20. Internationalization and Localization
- Locale Support
- Multibyte Character Sets
- Summary
- Chapter 21. Security
- Securing the PostgreSQL Data Files
- Securing Network Access
- Securing Tables
- Summary
- index
- index_SYMBOL
- index_A
- index_B
- index_C
- index_D
- index_E
- index_F
- index_G
- index_H
- index_I
- index_J
- index_K
- index_L
- index_M
- index_N
- index_O
- index_P
- index_Q
- index_R
- index_S
- index_T
- index_U
- index_V
- index_W
PostgreSQL (2nd Edition)
ISBN: 0672327562
EAN: 2147483647
EAN: 2147483647
Year: 2005
Pages: 220
Pages: 220
Authors: Korry Douglas
- Chapter I e-Search: A Conceptual Framework of Online Consumer Behavior
- Chapter X Converting Browsers to Buyers: Key Considerations in Designing Business-to-Consumer Web Sites
- Chapter XI User Satisfaction with Web Portals: An Empirical Study
- Chapter XII Web Design and E-Commerce
- Chapter XVI Turning Web Surfers into Loyal Customers: Cognitive Lock-In Through Interface Design and Web Site Usability