PostgreSQL 7.1.3 Tutorial

The 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