Résumé
Complete with a CD-ROM of the PostgreSQL Application Server, LXP, this comprehensive new volume shows you how to compile PostgreSQL from source, create a database, and configure PostgreSQL to accept client-server connections. It also covers the many advanced features, such as transactions, versioning, replication, and referential integrity that enable developers and DBAs to use PostgreSQL for serious business applications. The thorough introduction to PostgreSQL's PL/pgSQL programming language explains how you can use this very useful but under-documented feature to develop stored procedures and triggers. The book includes a complete command reference, and database administrators will appreciate the chapters on user management, database maintenance, and backup & recovery. With Practical PostgreSQL, you will discover quickly why this open source database is such a great open source alternative to proprietary products from Oracle, IBM, and Microsoft.
Contents
Preface
PART 1: Introduction & Installation
Chapter 1. What Is PostgreSQL?
Open Source Free Version
PostgreSQL Feature Set
Where to Proceed from Here
Chapter 2. Installing PostgreSQL
Preparing for Installation
10 Steps to Installing PostgreSQL
PART 2: Using PostgreSQL
Chapter 3. Understanding SQL
Introduction to SQL
Introduction to Relational Databases
SQL Statements
Data Types
Tables in PostgreSQL
Chapter 4. Using SQL with PostgreSQL
Introduction to psql
Using Tables
Adding Data with INSERT and COPY
Retrieving Rows with SELECT
Modifying Rows with UPDATE
Removing Rows with DELETE
Using Sub-Queries
Using Views
Further SQL Application
Chapter 5. Operators and Functions
Operators
Functions
Chapter 6. PostgreSQL Clients
The psql Client: Advanced Topics
PgAccess: A Graphical Client
Chapter 7. Advanced Features
Indices
Advanced Table Techniques
Arrays
Automating Common Routines
Transactions and Cursors
Extending PostgreSQL
PART 3: Administrating PostgreSQL
Chapter 8. Authentication and Encryption
Client Authentication
Encrypting Sessions
Chapter 9. Database Management
Starting and Stopping PostgreSQL
Initializing the Filesystem
Creating and Removing a Database
Maintaining a Database
Backing Up and Restoring Data
Chapter 10. User and Group Management
Managing Users
Managing Groups
Granting Privileges
PART 4: PostgreSQL Programming
Chapter 11. PL/pgSQL
Adding PL/pgSQL to Your Database
Language Structure
Using Variables
Controlling Program Flow
PL/pgSQL and Triggers
Chapter 12. JDBC
Building the PostgreSQL JDBC Driver
Using the PostgreSQL Driver
Using JDBC
Issues Specific to PostgreSQL and JDBC
Chapter 13. LXP
Why Use LXP?
Core Features
Installing and Configuring LXP
Understanding LXP Mark-Up
LXP Variables and Objects
Using Cookies with LXP
Tag Parsing
Branching Logic
Loop Iteration
Content Inclusion
Displaying Foreign Tags with
PART 5: Command Reference
Chapter 14. PostgreSQL Command Reference
Appendix A. Multibyte Encoding Types
Appendix B. Backend Options for postgres
Appendix C. Binary COPY Format
Appendix D. Internal psql Variables
Index
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | O'Reilly |
| Auteur(s) | John C. Worsley, Joshua D. Drake |
| Parution | 10/02/2002 |
| Nb. de pages | 620 |
| Format | 17,8 x 23,3 |
| Couverture | Broché |
| Poids | 933g |
| Intérieur | Noir et Blanc |
| EAN13 | 9781565928466 |
| ISBN13 | 978-1-56592-846-6 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
