PostgreSQL

Welcome to the PostgreSQL Tutorial. The following few chapters are intended to give a simple introduction to PostgreSQL, relational database concepts, and the SQL language to those who are new to any one of these aspects. We only assume some general knowledge about how to use computers. No particular Unix or programming experience is required. This part is mainly intended to give you some hands-on experience with important aspects of the PostgreSQL system. It makes no attempt to be a complete or thorough treatment of the topics it covers.

After you have worked through this tutorial you might want to move on to reading Part II to gain a more formal knowledge of the SQL language, or Part IV for information about developing applications for PostgreSQL. Those who set up and manage their own server should also read Part III.

Table of Contents

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. Window Functions

3.6. Inheritance

3.7. Conclusion

Privacy Policy | Code of Conduct | About PostgreSQL | Contact

Copyright © 1996-2023 The PostgreSQL Global Development Group