JSONB containment query

sql

SELECT * FROM events WHERE payload @> '{"event_type":"signup"}'::jsonb;

Explanation

See summary for usage details.

Learn the surrounding workflow

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

Same sheet · prioritizing JSONB, Arrays, and Date/Time Recipes

Extract a text value from a JSONB document.

Open In sheetsql2 tag match

Fetch a sorted subset of rows.

Open In sheetsql1 tag match

Accelerate JSONB containment queries.

Open In sheetsql1 tag match

Use a CTE to structure a multi-step query.

Open In sheetsql1 tag match

Open an interactive psql session to a database.

Create a new database in the cluster.