Documentation → PostgreSQL 7.1

Supported Versions: Current (17) / 16 / 15 / 14 / 13

Development Versions: devel

Unsupported versions: 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4 / 7.3 / 7.2 / 7.1

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 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

Prev	Home	Next
PostgreSQL 7.1.3 Documentation		SQL