FUNCTIONS / JSON FUNCTIONS AND OPERATORS

jsonb_pretty

Converts the given JSON value to pretty-printed, indented text.

Signatures & examples

jsonb_pretty ( jsonb ) → text

Converts the given JSON value to pretty-printed, indented text.

jsonb_pretty('[{"f1":1,"f2":null}, 2]') → [
    {
        "f1": 1,
        "f2": null
    },
    2
]

Version history 2

Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source