PostgreSQL Tutorial — One-Page Cheat Sheet
The world's most advanced open-source relational database.
PostgreSQL Tutorial
- Postgres HOME
- Intro
- Install / psql
- Data Types
- CREATE TABLE
- SELECT
- INSERT
- UPDATE
- DELETE
- JOINs
- GROUP BY / Aggregates
- Subqueries
- CTEs (WITH)
- Window Functions
Postgres Special
- JSON / JSONB
- Arrays
- ENUM & Domains
- UUID
- Full-text Search
- GIN / GiST Indexes
- Extensions (postgis, pgvector)
- Partitioning
Schema & Performance
- Constraints
- Indexes
- EXPLAIN ANALYZE
- Transactions / Isolation
- MVCC & VACUUM
- Roles & Permissions
- pg_dump / Restore
- Replication