json rendering without pretty option (compact)

From: Nicolas Paris <niparisco(at)gmail(dot)com>
To: Forums postgresql <pgsql-general(at)postgresql(dot)org>
Subject: json rendering without pretty option (compact)
Date: 2016-10-18 17:00:08
Message-ID: CA+ssMOQVmonMMdjKcwrMALcLCYWPFEVvf37YL2bLQkTbBkHNyg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I want to minimize postgresql json size when I fetch them.
I translate columnar table to json thought json_build_object/array or even
row_to_jeon.

While row_to_json do have a "pretty_bool" option, the latter do not. Each
json object/array I build contains spaces.

Is there a workaround ?
Is there a plan to add this feature on future version ?

(PG 9.6)

Thank you by advance,

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Edilmar LISTAS 2016-10-18 17:12:28 Re: Problem changing default data_directory in PG 9.6 + CentOS6
Previous Message Edilmar LISTAS 2016-10-18 16:49:37 Re: Problem changing default data_directory in PG 9.6 + CentOS6