JSON ​

The JSON data type stores variable-length JSON documents up to 64,000 bytes.

Note that the JSON data type retains an exact copy of the input text. Consequently, processing functions must reparse the JSON on each execution. Additionally, JSON data type does not validate JSON syntax. For syntax validation, use JSONB instead.

Example: ​

Create a table with a column json_data of data type JSON.

CREATE TABLE jsontable (DATA json);
INSERT
	INTO
	jsontable
VALUES ('{"c":3, "b":2, "a":1}');