Livre Practical PostgreSQL - J.Worsley J.Drake -

Practical PostgreSQL

John C. Worsley , Joshua D. Drake

O'Reilly cdrom

Prix : 45,90 EUR

Généralement disponible entre 1 et 3 semaines

Caractéristiques

Practical PostgreSQL

Editeur(s) : O'Reilly
Auteur(s) : J.Worsley J.Drake
Collection :
Profil :
Niveau :

Parution : 10/02/2002
Edition : 1ère édition
Nb de pages : 620 pages
Format : 17,8 x 23,3
Couverture : Broché
Poids : 933 g
Intérieur : Noir et Blanc

Type produit : Livre
Langue : Anglais
ISBN10 : 1-56592-846-6
ISBN13 : 978-1-56592-846-6
EAN13 : 9781565928466
Inclus : CD-ROM

Présentation par l'éditeur

Arguably the most capable of all the open source databases, PostgreSQL is an object-relational database management system first developed in 1977 by the University of California at Berkeley. In spite of its long history, this robust database suffers from a lack of easy-to-use documentation. Practical PostgreSQL fills that void with a fast-paced guide to installation, configuration, and usage.

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