Functions / Json Functions And Operators

jsonb_pretty

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

Reading PG 18current·documented in 13 of 27 versions, 9.5 to 20

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