September 26, 2024: PostgreSQL 17 Released!
Unsupported versions: 7.0 / 6.5 / 6.4
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

Bibliography

Selected references and readings for SQL and Postgres.

Some white papers and technical reports from the original Postgres development team are available at the University of California, Berkeley, Computer Science Department web site

SQL Reference Books

The Practical SQL Handbook , Judith Bowman, Sandra Emerson, and Marcy Darnovsky, ISBN: 0-201-44787-8, 1996, Addison-Wesley.

A Guide to the SQL Standard , C. J. Date and Hugh Darwen, ISBN: 0-201-96426-0, 1997, Addison-Wesley.

An Introduction to Database Systems , C. J. Date, 1994, Addison-Wesley.

Understanding the New SQL , Jim Melton and Alan R. Simon, ISBN: 1-55860-245-3, 1993, Morgan Kaufmann.

Principles of Database and Knowledge , Jeffrey D. Ullman, Computer Science Press , 1988 .

PostgreSQL-Specific Documentation

The PostgreSQL Administrator's Guide , 2000-05-01, The PostgreSQL Global Development Group.

The PostgreSQL Developer's Guide , 2000-05-01, The PostgreSQL Global Development Group.

The PostgreSQL Programmer's Guide , 2000-05-01, The PostgreSQL Global Development Group.

The PostgreSQL Tutorial Introduction , 2000-05-01, The PostgreSQL Global Development Group.

The PostgreSQL User's Guide , 2000-05-01, The PostgreSQL Global Development Group.

Enhancement of the ANSI SQL Implementation of PostgreSQL , Stefan Simkovics, November 29, 1998, Department of Information Systems, Vienna University of Technology .

The Postgres95 User Manual , A. Yu and J. Chen, The POSTGRES Group , Sept. 5, 1995, University of California, Berkeley CA.

Proceedings and Articles

Partial indexing in POSTGRES: research project , Nels Olson, 1993, ISSN: UCB Engin T7.49.1993 O676, University of California, Berkeley CA.

A Unified Framework for Version Modeling Using Production Rules in a Database System , L. Ong and J. Goh, April, 1990, ISSN: ERL Technical Memorandum M90/33, University of California, Berkeley CA.

The Postgres Data Model , L. Rowe and M. Stonebraker.

Generalized partial indexes , P. Seshadri and A. Swami, 1995, ISSN: Cat. No.95CH35724, IEEE Computer Society Press.

The Design of Postgres , M. Stonebraker and L. Rowe.

The Design of the Postgres Rules System, M. Stonebraker, E. Hanson, and C. H. Hong.

The Postgres Storage System , M. Stonebraker.

A Commentary on the Postgres Rules System , M. Stonebraker, M. Hearst, and S. Potamianos.

The case for partial indexes (DBMS) , M. Stonebraker.

The Implementation of Postgres , M. Stonebraker, L. A. Rowe, and M. Hirohama.

On Rules, Procedures, Caching and Views in Database Systems , M. Stonebraker and et al.