GSoC/GCI Archive
Google Summer of Code 2010 PostgreSQL

Add JSON datatype to PostgreSQL

by Joey Adams for PostgreSQL

JSON is a text serialization format similar in purpose to XML. PostgreSQL already has an XML datatype, along with XML access and manipulation functions such as xmlconcat, xmlforest, etc.. I propose adding a JSON datatype and related functions to PostgreSQL. Because JSON's structure is somewhat different than XML's, the json* functions will likely be different. When this project is completed, it will add a JSON datatype to PostgreSQL along with ways to convert sets to/from JSON.