数智融合计算服务 DATAARTSFABRIC-JSON/JSONB函数:jsonb_pretty(jsonb)

时间:2025-06-17 08:50:09

jsonb_pretty(jsonb)

描述:以缩进的JSON文本形式返回。

返回类型:jsonb

示例:
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
SELECT jsonb_pretty('{"a":{"b":{"c":1, "d":2}}, "e":3}'::jsonb);
    jsonb_pretty
---------------------
 {                  +
     "a": {         +
         "b": {     +
             "c": 1,+
             "d": 2 +
         }          +
     },             +
     "e": 3         +
 }
(1 row)
support.huaweicloud.com/devg-fabric/dataartsfabric_sql_04_0226.html