Postgres 9.4 JSON response

[dukedougal]

Hello

I am using Postgres 9.4 with JSONB fields.

I want to do a query which returns JSON to the web browser from Nginx.

How do I do this? Currently I get a result set back that contains the field name and then JSON is provided as text.

thanks!

[agentzh]

@dukedougal Hmm, maybe we could let ngx_rds_json module support such JSONB fields directly.

[dukedougal]

After I posted the issue here I tried the following query which pretty much returns the JSON that I need.

There might be improvements or better ways to do it but at the moment I think this is probably good enough.

select row_to_json(row) from (select key, snapk->'name' as name, snapk->>'keywords' as keywords from snapk LIMIT 50 $offset_string) row;

[majj]

+1