Skip to content

Glossary: PostgreSQL for Developers

jsonb operators

Also written: ->, ->>, ?, ||, -, jsonb_build_object, jsonb_array_elements_text, jsonb_typeof

-> returns a key's value as JSON, ->> as text, ? tests whether a key exists, || merges objects and - removes a key. Functions such as jsonb_build_object build JSON.

Where the book teaches it

Related terms

jsonbcontainment