PostgreSQL 18 SQL Cheat Sheet, Everyday Commands for psql, Printable PDF Reference, US Letter and A4

PostgreSQL® 18 SQL: everyday commands, from Minnesota Programming (shop name MnProgramming). A 4-page printable reference for people learning SQL on PostgreSQL 18 and typing into psql.

Each command is shown in its everyday form, with the common trap next to it, such as UPDATE or DELETE without WHERE.

WHAT'S INSIDE
- psql: connect, list databases and tables, describe a table, get help
- Make and change tables: CREATE TABLE with an identity key, common data types, ALTER TABLE, DROP TABLE
- Add, change and remove rows: INSERT with RETURNING, UPDATE, DELETE
- Query one table: clause order, ORDER BY and nulls, LIMIT and OFFSET, LIKE, IN, BETWEEN, IS NULL
- Combine tables: JOIN, LEFT JOIN, FULL JOIN, and one worked LEFT JOIN
- Summarize: count, sum, GROUP BY, WHERE vs HAVING
- Transactions: a practice update that rolls back; COMMIT is described separately

NOT COVERED
Indexes and query speed, users and permissions, backups, bulk loading, window functions, WITH queries, JSON, upserts, and database products other than PostgreSQL.

FILES (INSTANT DOWNLOAD)
- US Letter PDF, 4 pages
- A4 PDF, 4 pages
- Plain-text version of the same content
This is a digital download. Nothing is shipped.

VERSION AND SOURCES
Written for PostgreSQL 18, using the version 18.6 documentation, checked 26 September 2026. PostgreSQL 19 was in beta on that date and is not covered. SQL explanations use the PostgreSQL 18 manual. The wording and examples are original. The examples were not run against a database.

HOW THIS WAS MADE
An AI assistant drafted the text and checked each fact against a cited section of the PostgreSQL 18 manual. The owner of Minnesota Programming reviewed and approved the final version. That owner states 15 years of industry experience.

LICENSE
For your own use in your own work. Please don't resell it, give the file away, or post it publicly.

QUESTIONS OR ERRORS
If a download doesn't work or you find a factual error, send a message through Etsy. I reply within two business days.

Not affiliated with or endorsed by the PostgreSQL project. PostgreSQL is a registered trademark of the PostgreSQL Community Association of Canada.