数智融合计算服务 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