The json_agg function is useful for creating JSON arrays from query results, which can be particularly handy when working with JSON data in PostgreSQL. Function Description Example Example Result tojson(anyelement) tojsonb(anyelement) Returns the value as json or jsonb.Arrays and composites are converted (recursively) to arrays and objects otherwise, if there is a cast from the type to json, the cast function will be used to perform the conversion otherwise, a scalar value is produced.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |