row_to_json white space

From: Mark Lybarger <mlybarger(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: row_to_json white space
Date: 2019-09-26 17:54:55
Message-ID: CAKM-gm+MJbLzgiZk-16ciCW+aLK35bpjyhuxT2wnSJWt9O5igw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

The row_to_json seems to strip white space:

select ROW_to_json(q) from (select 'foo a bar' as TEST) q;

any help on how to preserve?

Thanks!
-mark-

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2019-09-26 18:29:46 Re: row_to_json white space
Previous Message Marco Ippolito 2019-09-26 17:10:40 Re: "Failed to connect to Postgres database"