Pretty Printing JSONB Rows
Last updated
Was this helpful?
Last updated
Was this helpful?
Who needs a document store when you can just use PostgreSQL's JSONB
data type? Viewing rows of JSONB
output can be challenging though because it defaults to printing them as a single line of text.
Fortunately, Postgres comes with a function for prettying up the format of the output of these rows --
h/t Jack Christensen