Documentation → PostgreSQL 6.4

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.

PostgreSQL

The PostgreSQL Development Team

Edited by

Thomas Lockhart

Table of Contents

Summary

I. Tutorial

1. Introduction

What is Postgres?
A Short History of Postgres
About This Release
Resources
Terminology
Notation
Y2K Statement
Copyrights and Trademarks

2. Architecture

Postgres Architectural Concepts

3. Getting Started

Setting Up Your Environment
Starting the Interactive Monitor (psql)
Managing 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
Time Travel
More Advanced Features

II. User's Guide

6. Setting Up Your Environment

7. Managing a Database

Database Creation
Alternate Database Locations
Accessing a Database
Destroying a Database

8. Data Types

Numeric Types
Monetary Type
Character Types