PostgreSQL Tutorial

PostgreSQL is a powerful open-source object-relational database system (ORDBMS), released under a flexible BSD-style license. Developers often pronounce it post-gress-Q-L. Its slogan: “The world’s most advanced open source relational database.”

In this tutorial you will learn how to install PostgreSQL, create databases and tables, and use common statements such as SELECT, INSERT, UPDATE, and DELETE.

Learning path

1. PostgreSQL Intro
2. Install PostgreSQL
3. Create Database
4. Create Table
5. SELECT
6. INSERT
7. UPDATE
8. DELETE
9. Summary

Example

SELECT * FROM company;

Dialect tip

Compared with MySQL, PostgreSQL often uses SERIAL or GENERATED … AS IDENTITY for auto-increment, prefers TEXT / VARCHAR for strings, and uses psql as the main CLI client.

Next: PostgreSQL Intro