Document data types

JSON data types are used for storing JSON (JavaScript Object Notation) data, as specified in RFC 4627. There are 2 JSON data types: json and jsonb. The values accepted by these data types are almost identical. The major practical difference between the two of them is one of efficiency. Most applications should prefer to store JSON data as jsonb unless there are specialized needs.

jsonpath is an XPath like query language for JSON. The root element in JSONPath is always referred to as $ regardless if it is an object or array.