Json Operators

Operator | RHS Type | Description ---------|----------|------------- -\> | text, int| Access field by name or index position, and return jsonb (docs) -\>\> | text, int| Access field by name or index position, and return text (docs) #\> | text[] | Access field by path, and return jsonb (docs) #\>\> | text[] | Access field by path, and return text (docs) || | jsonb | Concatenate LHS and RHS (docs) - | text | Delete all values with key of RHS (docs) @\> | jsonb | Does element contain RHS? (docs) <@ | jsonb | Does RHS contain element? (docs) ? | text | Is RHS a top-level key? (docs)