Skip to content

Glossary: PostgreSQL for Developers

containment

Also written: @>

The @> operator asks whether the left JSON contains the right JSON, as in details @> '{"roast": "medium"}'. It's the usual way to filter on jsonb and can use a GIN index.

Where the book teaches it

Related terms

jsonbGIN index