The PostgreSQL Global Development Group

Copyright © 1996-2001 by PostgreSQL Global Development Group

Table of Contents

1. SQL

1.1. The Relational Data Model

1.2. Relational Data Model Formalities

1.2.1. Domains vs. Data Types

1.3. Operations in the Relational Data Model

1.3.1. Relational Algebra

1.3.2. Relational Calculus

1.3.3. Tuple Relational Calculus

1.3.4. Relational Algebra vs. Relational Calculus

1.4. The SQL Language

1.4.1. Select

1.4.2. Data Definition

1.4.3. Data Manipulation

1.4.4. System Catalogs

1.4.5. Embedded SQL

2. Architecture

2.1. Postgres Architectural Concepts

3. Getting Started

3.1. Setting Up Your Environment

3.2. Starting the Interactive Monitor (psql)

3.3. Managing a Database

3.3.1. Creating a Database

3.3.2. Accessing a Database

3.3.3. Destroying a Database

4. The Query Language

4.1. Interactive Monitor

4.2. Concepts

4.3. Creating a New Table

4.4. Populating a Table with Rows

4.5. Querying a Table

4.6. Redirecting SELECT Queries

4.7. Joins Between Tables

4.8. Updates

4.9. Deletions

4.10. Using Aggregate Functions

5. Advanced Postgres SQL Features

5.1. Inheritance

5.2. Non-Atomic Values

5.2.1. Arrays

5.3. More Advanced Features

List of Figures

2-1. How a connection is established

List of Examples

1-1. The Suppliers and Parts Database

1-2. An Inner Join

1-3. A Query Using Relational Algebra

1-4. Simple Query with Qualification

1-5. Aggregates

1-6. Aggregates

1-7. Having

1-8. Subselect

1-9. Subselect in FROM

1-10. Union, Intersect, Except

1-11. Table Creation

1-12. Create Index