FunctionsJSON

json_all_paths

Parses each JSON document and returns a JSON array of observed nested paths in dot-and-index notation.

json_all_paths(…) → JSON

Kind · scalar

Parses each JSON document and returns a JSON array of observed nested paths in dot-and-index notation.

Part of the JSON family.

json_agg_strict

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

json_all_paths_with_types

Parses each JSON document and returns a JSON array of path:type entries for all observed nested values.