PostgreSQL: Documentation: 9.2: JSON Functions

PostgreSQL: Documentation: 9.2: JSON Functions

时间:2015-07-13 17:42来源:网络整理 作者:KKWL 点击:
9.15. JSON Functions Table 9-40 shows the functions that are available for creating JSON (see Section 8.14) data. Table 9-40. JSON Support Functions FunctionDescriptionExampleExample Result array_to_json(anyarray [,pretty_bool])Returns the

9.15. JSON Functions

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

Table 9-40. 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"}

------分隔线----------------------------