PostgreSQL Tutorial

Covering v6.3 for general release

by The PostgreSQL Development Team

Edited by Thomas Lockhart

(last updated 1998-02-23)

PostgreSQL is copyright (C) 1998 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
Copyrights and Trademarks
2. Architecture
Postgres Architectural Concepts
3. Getting Started
Setting Up Your Environment
Starting the Interactive Monitor (psql)
Managing a Database
Creating a Database
Accessing a Database
Destroying a Database
4. 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
5. Advanced Postgres SQL Features
Inheritance
Non-Atomic Values
Arrays
Time Travel
More Advanced Features
SQL References
Index
  Next
  Summary