Cheat Sheet logoCheat Sheet Today
PostgreSQL Cheat Sheet/Update JSONB path

Set or replace a value inside a JSONB document.

Back to sheetBrowse commands
Sign in to save
Section: JSONB, Arrays, and Date/Time Recipes

Update JSONB path

sql
sql
UPDATE events
SET payload = jsonb_set(payload, '{status}', '"processed"', true)
WHERE event_id = 1;
Explanation

See summary for usage details.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing JSONB, Arrays, and Date/Time Recipes
Update rows
Modify matching rows.
OpenIn sheetsql1 tag match
Update from another table
Update rows using another table in the same statement.
OpenIn sheetsql1 tag match
Create GIN index on JSONB
Accelerate JSONB containment queries.
OpenIn sheetsql1 tag match
Extract JSONB field
Extract a text value from a JSONB document.
OpenIn sheetsql1 tag match
Connect to a database
Open an interactive psql session to a database.
OpenIn sheetbash
Create database
Create a new database in the cluster.
OpenIn sheetsql