JSON Functions
| PostgreSQL 9.2.20 Documentation | ||||
|---|---|---|---|---|
| Prev | Up | Chapter 9. Functions and Operators | Next | |
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"} |