PostgreSQL 9.0 Reference Manual - Volume 1A
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,
- View sample pages (individual pages in image format)
- View sample in PDF (contents and selected pages, 230 kB)
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:
- Barnes & Noble.com - USA / International
- The Book Depository.com - USA / International
- Powells.com - USA / International
- Amazon.com - USA / International (note)
- The Book Depository.co.uk - United Kingdom / Europe / International (note)
- Amazon.co.uk - United Kingdom / Europe / International (note)
- Waterstones.com - UK / Europe / International
- Bookzilla.de - Germany / Europe
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 firstname.lastname@example.org for assistance.
If you are not completely satisfied with your purchase for any reason we will gladly issue a full refund or replacement (details).
- PostgreSQL 9.0 Reference Manual - Volume 1B by PostgreSQL Global Development Group (ISBN 978-1-906966-05-8)
- PostgreSQL 9.0 Reference Manual - Volume 2 by PostgreSQL Global Development Group (ISBN 978-1-906966-06-5)
- PostgreSQL 9.0 Reference Manual - Volume 3 by PostgreSQL Global Development Group (ISBN 978-1-906966-07-2)
- The XML 1.0 Standard (5th Edition) by W3C XML Working Group (ISBN 0-9546120-9-4)
For questions about this book, please use our email address email@example.com.
Table of Contents
- Publisher's Preface
- The SQL Language
- SQL Syntax
- Data Definition
- Data Manipulation
- Data Types
- Functions and Operators
- Type Conversion
- Concurrency Control
- Performance Tips
- PostgreSQL Error Codes
- Date/Time Support
- SQL Key Words
- SQL Conformance
Supplementary Electronic Volumes
Additional volumes available in PDF format only.
- PostgreSQL Reference Manual (version 8.2.4) - Volume 1 (June 2007, ISBN 0954612027)
- PostgreSQL Reference Manual (version 8.2.4) - Volume 2 (June 2007, ISBN 0954612035)
- PostgreSQL Reference Manual (version 8.2.4) - Volume 3 (June 2007, ISBN 0954612043)