- publishing free software manuals
Picture of Cover

PostgreSQL 9.0 Reference Manual - Volume 1A
The SQL Language

by: The PostgreSQL Global Development Group

Paperback (6"x9"), 454 pages - New release! (now shipping - December 2010)
Retail Price: $19.95 (£14.95 in UK)
ISBN-13: 978-1-906966-04-1

About the Book

This manual is the part of the official reference documentation for the PostgreSQL RDBMS (version 9.0.1). This volume describes the SQL language specification as implemented by PostgreSQL, including syntax, data types, functions and operators, indexes and transactions. The new XML datatypes and full-text index support of PostgreSQL 9 are also fully documented.

This volume is part of a set. The separate Volume 1B "SQL Command Reference" (ISBN 978-1-906966-05-8) contains the documentation for every PostgreSQL command from ABORT to VALUES. PostgreSQL client and server command-line tools are also documented in Volume 1B. Volumes 1A and 1B are intended to be used together.

The further additional volumes of this series are Volume 2, the "Programming Guide" (ISBN 978-1-906966-06-5), and Volume 3, the "Server Administration Guide" (ISBN 978-1-906966-07-2).

The authors of this manual are the developers of PostgreSQL.

You can examine the contents of the printed book here,

For each copy of this manual sold $1 is donated to the PostgreSQL project.

As of October 2015 the total amount donated is $4,611 from the sale of this and previous editions.

This book is freely redistributable, under the same license as PostgreSQL itself.


You can buy the book online at the following bookstores:

The manual can also be ordered from most physical bookstores using the ISBN number.

Print out the following flyer for detailed bookstore and library ordering information,

If the title is listed as "out-of-stock", please ask the bookstore to place an order with one of the wholesale suppliers given in the flyer.

If you encounter any difficulties in obtaining this book, please send an email to sales@network-theory.co.uk for assistance.

If you are not completely satisfied with your purchase for any reason we will gladly issue a full refund or replacement (details).

Related Titles

Further Information

For questions about this book, please use our email address sales@network-theory.co.uk.

Table of Contents

  1. Publisher's Preface
  2. The SQL Language
  3. SQL Syntax
  4. Data Definition
  5. Data Manipulation
  6. Queries
  7. Data Types
  8. Functions and Operators
  9. Type Conversion
  10. Indexes
  11. Concurrency Control
  12. Performance Tips
  13. PostgreSQL Error Codes
  14. Date/Time Support
  15. SQL Key Words
  16. SQL Conformance
  17. Bibliography
  18. Index

Supplementary Electronic Volumes

Additional volumes available in PDF format only.

Previous Editions