Yes — indexing, querying with @>, path expressions, and common update patterns. Postgres's killer feature for JSON-heavy apps.

All the common ones: \l, \dt, \d, \df, \e for editing, \i for files. Essential for DBA work in the terminal.

Yes — EXPLAIN vs EXPLAIN ANALYZE, common plan nodes (Seq Scan, Index Scan, Hash Join), and spotting red flags.

Yes — ROW_NUMBER(), RANK(), LAG/LEAD, running totals. With common patterns like 'top N per group' and 'gap detection'.

PostgreSQL Cheatsheet | DevTools Surf

About PostgreSQL Cheatsheet

psql meta-commands, JSONB, indexing, EXPLAIN. Part of the DevTools Surf developer suite. Browse more tools in the Cheatsheets collection.

PostgreSQL traces its origins to the POSTGRES project at UC Berkeley, led by Michael Stonebraker starting in 1986. 'Postgre-SQL' was renamed in 1996.
PostgreSQL's JSONB type, added in version 9.4 (2014), can be indexed with GIN indexes, making it competitive with document databases like MongoDB.
PostgreSQL supports over 40 data types natively, including arrays, ranges, geometric types, network addresses, and even full-text search vectors.

Does it cover JSONB?: Yes — indexing, querying with @>, path expressions, and common update patterns. Postgres's killer feature for JSON-heavy apps.
psql commands?: All the common ones: \l, \dt, \d, \df, \e for editing, \i for files. Essential for DBA work in the terminal.
What about EXPLAIN?: Yes — EXPLAIN vs EXPLAIN ANALYZE, common plan nodes (Seq Scan, Index Scan, Hash Join), and spotting red flags.
Window functions?: Yes — ROW_NUMBER(), RANK(), LAG/LEAD, running totals. With common patterns like 'top N per group' and 'gap detection'.

psql meta-commands, JSONB, indexing, EXPLAIN. Part of the DevTools Surf developer suite. Browse more tools in the Cheatsheets collection.

PostgreSQL traces its origins to the POSTGRES project at UC Berkeley, led by Michael Stonebraker starting in 1986. 'Postgre-SQL' was renamed in 1996.
PostgreSQL's JSONB type, added in version 9.4 (2014), can be indexed with GIN indexes, making it competitive with document databases like MongoDB.
PostgreSQL supports over 40 data types natively, including arrays, ranges, geometric types, network addresses, and even full-text search vectors.

Does it cover JSONB?: Yes — indexing, querying with @>, path expressions, and common update patterns. Postgres's killer feature for JSON-heavy apps.
psql commands?: All the common ones: \l, \dt, \d, \df, \e for editing, \i for files. Essential for DBA work in the terminal.
What about EXPLAIN?: Yes — EXPLAIN vs EXPLAIN ANALYZE, common plan nodes (Seq Scan, Index Scan, Hash Join), and spotting red flags.
Window functions?: Yes — ROW_NUMBER(), RANK(), LAG/LEAD, running totals. With common patterns like 'top N per group' and 'gap detection'.