This page in other versions: 9.2 / 9.3 / 9.4  |  Development versions: devel

9.15. JSON Functions

Table 9-39 shows the functions that are available for creating JSON (see Section 8.14) data.

Table 9-39. JSON Support Functions

Function Description Example Example Result
array_to_json(anyarray [, pretty_bool]) Returns the array as JSON. A PostgreSQL multidimensional array becomes a JSON array of arrays. Line feeds will be added between dimension 1 elements if pretty_bool is true. array_to_json('{{1,5},{99,100}}'::int[]) [[1,5],[99,100]]
row_to_json(record [, pretty_bool]) Returns the row as JSON. Line feeds will be added between level 1 elements if pretty_bool is true. row_to_json(row(1,'foo')) {"f1":1,"f2":"foo"}
Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group