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.