Practical PostgreSQL

Description

Copyright; Table of Contents; Preface; I: Introduction & Installation; 1: What Is PostgreSQL?; Open Source Free Version; PostgreSQL Feature Set; Where to Proceed from Here; 2: Installing PostgreSQL; Preparing for Installation; 10 Steps to Installing PostgreSQL; II: Using PostgreSQL; 3: Understanding SQL; Introduction to SQL; Introduction to Relational Databases; SQL Statements; Data Types; Tables in PostgreSQL; 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.;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. 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 fe. Copyright Table of Contents Preface I: Introduction & Installation 1: What Is PostgreSQL? Open Source Free Version PostgreSQL Feature Set Where to Proceed from Here 2: Installing PostgreSQL Preparing for Installation 10 Steps to Installing PostgreSQL II: Using PostgreSQL 3: Understanding SQL Introduction to SQL Introduction to Relational Databases SQL Statements Data Types Tables in PostgreSQL 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-QueriesUsing Views Further SQL Application 5: Operators and Functions Operators Functions 6: PostgreSQL Clients The psql Client: Advanced Topics PgAccess: A Graphical Client 7: Advanced Features Indices Advanced Table Techniques Arrays Automating Common Routines Transactions and Cursors Extending PostgreSQL III: Administrating PostgreSQL 8: Authentication and Encryption Client Authentication Encrypting Sessions 9: Database Management Starting and Stopping PostgreSQL Initializing the Filesystem Creating and Removing a Database Maintaining a Database. Backing Up and Restoring Data10: User and Group Management Managing Users Managing Groups Granting Privileges IV: PostgreSQL Programming 11: PL/pgSQL Adding PL/pgSQL to Your Database Language Structure Using Variables Controlling Program Flow PL/pgSQL and Triggers 12: JDBC Building the PostgreSQL JDBC Driver Using the PostgreSQL Driver Using JDBC Issues Specific to PostgreSQL and JDBC 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 InclusionDisplaying Foreign Tags with V: Command Reference 14: PostgreSQL Command Reference A: Multibyte Encoding Types B: Backend Options for postgres C: Binary COPY Format D: Internal psql Variables Index About the Authors Colophon.