Use jsonb_pretty for all printed JSONB in Postgres

1
votes

Can .psqlrc be configured so that jsonb_pretty is applied to every JSONB column printed to console?

Expanded display automatic mode is very useful: https://stackoverflow.com/a/16108898/1007926

I want to use both jsonb_pretty and expanded display. Does jsonb_pretty work by inserting newlines into the string? I suppose this would this cause problems if applied to every JSONB select.

jsonb_pretty: https://www.postgresql.org/docs/current/functions-json.html#FUNCTIONS-JSON-PROCESSING-TABLE

1
postgresqlpsqljsonb

1 Answers

3
votes

No, it is not possible. psql has not any support for pretty print of JSON types.