On 9/26/19 11:54 AM, Mark Lybarger wrote:
Ccing the list so folks know the problem is solved.
Problem is on my end. My tool was showing the space removed and infact
it wasn't. Copy paste from dbeaver to notepad++ shows the spaces are
preserved.
On Thu, Sep 26, 2019 at 2:49 PM Adrian Klave
On 9/26/19 10:54 AM, Mark Lybarger wrote:
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?
Like Rob I do not see it:
test=# select version();
version
On 9/26/19 11:54 AM, Mark Lybarger wrote:
select ROW_to_json(q) from (select 'foo a bar' as TEST) q;
Not here
postgres=# select ROW_to_json(q) from (select 'foo a bar' as TEST) q;
row_to_json
---
{"test":"foo a bar"}
(1 row)
po
