JSON

PostgreSQL has built-in support for JSON with a great range of processing functions, operators, and complete indexing support. The documentation covers all the details in the chapters entitled JSON Types and JSON Functions and Operators.

PostgreSQL implemented a very simple JSON data type back in the 9.2 release. At that time, the community pushed for providing a solution for JSON users, in contrast to the usual careful pace, though still speedy. The JSON data type is actually text under the hood, with a verification that the format is valid JSON input, much like XML.