Using JSON with PostgreSQL · shard-db HN Explorer

Features review and benchmarks of various ways to store JSON in PostgreSQL

I found it quite annoying that jsonb does not support /u0000 in strings.

I was looking for a way to pretty print json in postgres today, the simplest I came up with is a 'json_mode.sql' script:

  \t on
  \pset pager always
  \pset format unaligned
  \setenv PAGER 'jq .'

then all selects of a json column are readable.

ttfkam 4y ago ↗

Why not:

jsonb_pretty(jsonb) → text

jsonb_to_record(jsonb) → record jsonb_to_recordset(jsonb) → setof record

I came across this while googling but it seems the jsonb_pretty function isn't available in my postgres

Using JSON with PostgreSQL (percona.com)