Using JSON with PostgreSQL | Hacker News Reader

Using JSON with PostgreSQL

percona.com

20 pointsPeterZaitsev5 comments

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.

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

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

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