• Title PostgreSQL 9.0 Reference Manual - Volume 1B: SQL Command Reference
• Author(s) PostgreSQL Global Development Group
• Publisher: Network Theory Ltd.; Revised edition edition (November 30, 2010)
• Paperback 488 pages
• eBook Online, HTML, PDF
• Language: English
• ISBN-10/ASIN: 1906966052
• ISBN-13: 978-1906966058
• Share This:  

Book Description

This manual is part of the official reference documentation for PostgreSQL 9.0. It describes all the SQL commands available in PostgreSQL.

There are over 140 commands from ABORT to VALUES each with a full usage synopsis, description, annotated parameter list and examples. Important commands such as SELECT and GRANT receive extended coverage. The associated client and server command-line tools like psql, pg_dump and pg_restore are also documented. This volume is part of a set. The separate Volume 1A: The SQL Language (ISBN 978-1-906966-04-1) documents the SQL language syntax, functions and datatypes as implemented by PostgreSQL.

Volumes 1A and 1B are intended to be used together. The further additional volumes of this series are Volume 2: Programming Guide (ISBN 978-1-906966-06-5), and Volume 3: Server Administration Guide (ISBN 978-1-906966-07-2). For each copy of this manual sold 1 USD is donated to the PostgreSQL project by the publisher, Network Theory Ltd.

• N/A

• Amazon

• PostgreSQL
• SQL - The Structured Query Language
• Database, Data Warehouse and Data Management

• PostgreSQL 9.0 Reference Manual - Volume 1A: The SQL Language
• The Mirror Site (1) - PDF

• The Internals of PostgreSQL (Hironobu Suzuki)

  This book describes the internals of PostgreSQL for database administrators and system developers. The main purposes of this book are to explain how each subsystem works, and to provide the whole picture of PostgreSQL.

• Postgres Succinctly (Peter Shaw)

  This book provides a concise overview to help you quickly understand and use PostgreSQL's unique features. It guides you from installing Postgres, to creating your first database, to using Postgres in a .NET application with ADO .NET and Entity Framework.

• PostgreSQL: An Introduction (WikiBooks)

  The purpose of this book is an introduction to the PostgreSQL specific aspects: its architecture, installing procedure, maintenance and optimization tasks. Thus it is primarily aimed to database administrators.

• O'Reilly® Practical PostgreSQL (John C. Worsley, et al)

  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.

• PostgreSQL: Introduction and Concepts (Bruce Momjian)

  The book is designed to lead the reader from their first database query through the complex queries needed to solve real-world problems. No knowledge of database theory or practice is required.

• PostgreSQL Notes for Professionals (Goalkicker)

  This book is the definitive guide to undocumented and partially-documented features of the PostgreSQL server. It helps you learn to apply the right solution at the right time, about avoiding risk, about making robust choices related to PostgreSQL databases.

• PostgreSQL Tutorials

  These tutorials offer readers a thorough overview of database basics, starting with an explanation of why you might need to use a PostgreSQL database, and following with a summary of what different database types have to offer when compared to alternatives like spreadsheets.

• PostgreSQL Database Handbook (Gabriel Canepa)

  This book provides a compilation of PostgreSQL tutorials that will help you set up and run your own database management system. It covers a wide range of topics, from installation and configuration, to custom commands and datatypes.