Practical PostgreSQL

Practical PostgreSQL

Comprehensive new volume shows you how to compile PostgreSQL from source, create a database, and configure PostgreSQL to accept client-server connections. Discover quickly why this open source database is such a great open source alternative to proprietary products from Oracle, IBM, and Microsoft.


This book is for anyone interested in utilizing the PostgreSQL object-relational database-management system (ORDBMS). The reader should be familiar with Linux- and UNIX-based systems, but is not expected to be a database guru. Although the test operating system for this book is Red Hat Linux, the tasks in this book that apply to Linux should apply to most UNIX variants without much modification.

Table of Contents

  • What is PostgreSQL?
  • Installing PostgreSQL
  • Understanding SQL
  • Using SQL with PostgreSQL
  • Operators and Functions
  • PostgreSQL Clients
  • Advanced Features
  • Authentication and Encryption
  • Database Management
  • User and Group Management
  • PL/pgSQL
  • JDBC
  • LXP
  • PostgreSQL Command Reference

Book Details

Author(s): John Worsley and Joshua Drake.
Format(s): HTML
Number of pages: 640
Link: Read online.

Leave a Reply