PostgreSQL Tutorial

The PostgreSQL Development Team

Edited by

Thomas Lockhart

PostgreSQL
is Copyright © 1996-9 by the Postgres Global Development Group.


Table of Contents
Summary
1. Introduction
What is Postgres?
A Short History of Postgres
The Berkeley Postgres Project
Postgres95
PostgreSQL
About This Release
Resources
Terminology
Notation
Y2K Statement
Copyrights and Trademarks
2. SQL
The Relational Data Model
Relational Data Model Formalities
Domains vs. Data Types
Operations in the Relational Data Model
Relational Algebra
Relational Calculus
Tuple Relational Calculus
Relational Algebra vs. Relational Calculus
The SQL Language
Select
Data Definition
Data Manipulation
System Catalogs
Embedded SQL
3. Architecture
Postgres Architectural Concepts
4. Getting Started
Setting Up Your Environment
Starting the Interactive Monitor (psql)
Managing a Database
Creating a Database
Accessing a Database
Destroying a Database
5. The Query Language
Interactive Monitor
Concepts
Creating a New Class
Populating a Class with Instances
Querying a Class
Redirecting SELECT Queries
Joins Between Classes
Updates
Deletions
Using Aggregate Functions
6. Advanced Postgres SQL Features
Inheritance
Non-Atomic Values
Arrays
Time Travel
More Advanced Features
Bibliography