PostgreSQL is a powerful, open-source relational database. Please read the official documentation to learn more.

Postgres by Example is a hands-on introduction to PostgreSQL using annotated SQL examples. Check out the first example or browse the full list below.

Prerequisites: PostgreSQL installed and the server running. Examples assume you can connect with psql; the default database is postgres unless noted. Start the server with your system's service manager or pg_ctl start as needed.

Unless stated otherwise, examples target current stable PostgreSQL. Use the latest version you can if something isn't working.

• First Query
• psql Basics

• SELECT Basics
• WHERE
• ORDER BY
• SELECT from a Table
• LIMIT and OFFSET
• DISTINCT
• NULLs
• Expressions

• Numeric Types
• Text Types
• Boolean and Dates
• UUID and JSONB

• CREATE TABLE
• Column Types and Constraints
• ALTER TABLE and DROP
• Primary Keys and Unique
• NOT NULL and DEFAULT

• INSERT
• UPDATE
• DELETE
• RETURNING

• INNER and LEFT JOIN
• RIGHT and FULL JOIN
• Self-Join
• UNION, INTERSECT, EXCEPT

• COUNT, SUM, AVG
• GROUP BY
• HAVING

• Scalar and IN Subqueries
• EXISTS and Derived Tables

• String and Numeric Functions
• Date Functions and COALESCE
• CASE

• CREATE INDEX
• When to Index

• BEGIN, COMMIT, ROLLBACK
• Savepoints

• CREATE VIEW

• Roles and GRANT

• psql Meta-commands
• COPY

Licensed under CC BY 4.0.

by Dariush Abbasi | source