Deletes all object fields that have null values from the given JSON value, recursively. If strip_in_arrays is true (the default is false), null array elements are also stripped. Otherwise they are not stripped. Bare null values are never stripped.
English manual coverage begins with PostgreSQL 7.1. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
strip_in_arrays is true (the default is false), null array elements are also stripped. Otherwise they are not stripped. Bare null values are never stripped.jsonb_strip_nulls ( target jsonb [,strip_in_arrays boolean] ) → jsonb → jsonbDeletes all object fields that have null values from the given JSON value, recursively. If
strip_in_arrays is true (the default is false), null array elements are also stripped. Otherwise they are not stripped. Bare null values are never stripped.{"inputs":[{"file":"functions-json.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"060b67147827d70ddcf5948833ddfbeada321366476016c8b8b7d68afda8045c","version":"18.7"},{"file":"functions-json.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"31b98fa7f00387abf441728c31918bfe8b368642bceeb8bba88a73c3fbd607de","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}Full definition and evidence JSON
center · PostgreSQL 18 · wiki-repair-20261023:f6f986412ca6c19598365f6b8c88bfa2a3f07df42277b62e9106284db2ca824c
Text language: en · wiki-repair-20261023:f6f986412ca6c19598365f6b8c88bfa2a3f07df42277b62e9106284db2ca824c