PostgreSQL 7.3.5 Tutorial

The PostgreSQL Global Development Group

Copyright © 1996-2002 The PostgreSQL Global Development Group

Table of Contents

Preface

1. What's In This Book

1. Getting Started

1.1. Installation

1.2. Architectural Fundamentals

1.3. Creating a Database

1.4. Accessing a Database

2. The SQL Language

2.1. Introduction

2.2. Concepts

2.3. Creating a New Table

2.4. Populating a Table With Rows

2.5. Querying a Table

2.6. Joins Between Tables

2.7. Aggregate Functions

2.8. Updates

2.9. Deletions

3. Advanced Features

3.1. Introduction

3.2. Views

3.3. Foreign Keys

3.4. Transactions

3.5. Inheritance

3.6. Conclusion