2 ms·
Why not: jsonb_pretty(jsonb) → text or jsonb_to_record(jsonb) → record jsonb_to_recordset(jsonb) → setof record https://www.postgresql.org/docs/current/func
by ttfkam 5y ago
Why not:
jsonb_pretty(jsonb) → text
or
jsonb_to_record(jsonb) → record
jsonb_to_recordset(jsonb) → setof record
https://www.postgresql.org/docs/current/functions-json.html https://www.postgresql.org/docs/current/functions-json.html
- jackhalford 5y agoI came across this while googling but it seems the jsonb_pretty function isn't available in my postgres