PostgreSQL Tutorial

The PostgreSQL Development Team

Edited by

Thomas Lockhart

PostgreSQL is Copyright © 1996-2000 by PostgreSQL Inc.

Table of Contents

1. Introduction

What is Postgres?

A Short History of Postgres

The Berkeley Postgres Project
Postgres95
PostgreSQL

About This Release

Terminology

Problem Reporting Guidelines

Identifying Bugs
What to report
Where to report bugs

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

More Advanced Features

Bibliography

		Next
		Summary