FunctionsJSON

json_agg

Collects values in group order and returns a JSON array containing each JSON-mapped row value.

json_agg(…) → JSON

Kind · aggregate

Collects values in group order and returns a JSON array containing each JSON-mapped row value.

Part of the JSON family.

is_valid_json

Validates each row as a JSON document and returns true for syntactically valid JSON values.

json_agg_strict

Collects non-NULL values in group order and returns a JSON array of their JSON-mapped tokens.