Skip to content

json_remove

Enterprise scalar function reference.

Function Snapshot

Field Value
Function json_remove
Category JSON and Object
Scope Scalar expression
Discovery SELECT * FROM pg_catalog.pg_proc WHERE proname = 'json_remove';

Purpose

Removes JSON content at a key or path and returns the updated object.

Syntax

SELECT json_remove({"a":1,"b":2}, 'a');

Parameters

  • Positional arguments as defined by overload signatures in pg_catalog.pg_proc.

Returns

  • Returns updated object value.

Null and Error Behavior

  • Missing keys/path elements generally return original/no-match semantics (path dependent).

Operational Notes

  • Use schema-qualified objects and parameterized queries for production pipelines.
  • Validate overload details in-cluster with pg_catalog.pg_proc and pg_get_function_result(oid).

Cross-References