Product Description

PostgreSQL Essential Reference is a reference book for developers and system administrators who are already familiar with SQL database concepts but that need clear and concise documentation that is specific to PostgreSQL.
The book is divided into 3 parts; Basic SQL Reference, PostgreSQL specifics, and PostgreSQL administration. On a whole, it provides a command, the syntax, available options, description, and example code. Readers will be able to easily utilize the code and concepts into their use f the product.
An added advantage to this book is that provides all reference material in two ways; alphabetically and by task. This is important because readers of the book will be looking for this information by both methods.

Product Details

• Amazon Sales Rank: #854702 in Books
• Published on: 2001-10-30
• Original language: English
• Number of items: 1
• Binding: Paperback
• 400 pages

From the Back Cover

PostgreSQL Essential Reference is a reference book for developers and system administrators who are already familiar with SQL database concepts but that need clear and concise documentation that is specific to PostgreSQL.
The book is divided into 3 parts; Basic SQL Reference, PostgreSQL specifics, and PostgreSQL administration. On a whole, it provides a command, the syntax, available options, description, and example code. Readers will be able to easily utilize the code and concepts into their use f the product.
An added advantage to this book is that provides all reference material in two ways; alphabetically and by task. This is important because readers of the book will be looking for this information by both methods.

About the Author

Barry Stinson , a charter member of his local LUG (lafix.org), is an active participant in the open source community. He is a day-to-day developer for PostgreSQL and he is currently the lead developer on the qikFax project, a linux fax server product, at sourceforge, (qikfax.sourceforge.net). Barry currently runs his own consulting company, Silicon Consulting Company, in Louisiana. His local clients include law firms, doctor offices, and various finance companies. Recently, he was given the task of replacing an existing database system, Microsoft's SQL Server, with PostgreSQL. Since the migration was completed over a year ago, there has been a marked improvement in system stability and the reduction of downtime.

Customer Reviews

Excellent reference
This is an excellent desktop reference for anyone running or coding for a PostgreSQL database (the title covers version 7.1.2). While nearly all the information in the book can be found for free on the net, this book does an excellent job of putting it all in one place and making it easy to find.

It covers PostgreSQL specific SQL, db administration and client and server side programming. Client side APIs covered include Perl, Python, PHP, libpq, libpq++ and JDBC. Server side procedural languages covered are PL/pgSQL, PL/Tcl and PL/Perl.

This shouldn't be bought by anyone new to PostgreSQL and looking for a getting started guide, Practical PostgreSQL from O'Reilly is more what you need there.