Practical PostgreSQL

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. 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 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. Arguably the most capable of all the open source databases, PostgreSQL is an object-relational database management system that--until now--lacked comprehensive, easy-to-use documentation. Practical PostgreSQL is a fast-paced guide that shows you how to get PostgreSQL installed, configured, and running. This comprehensive book delves into the many advanced features of the PostgreSQL Application Server, LXP, including the the use of SQL within PostgreSQL, and covers basic PostgreSQL database administration. COMPUTERS / Database Management / Data Mining