Re: return jsonb without field label - Mailing list pgsql-general

From Adrian Klaver
Subject Re: return jsonb without field label
Date
Msg-id 5597DDCF.2060605@aklaver.com
Whole thread Raw
In response to return jsonb without field label  ("john.tiger" <john.tigernassau@gmail.com>)
List pgsql-general
On 07/03/2015 06:28 PM, john.tiger wrote:
> have tables with :  create table mydocs (id serial primary key, data jsonb)
>
> when I do a select data from mydocs it comes back as {data: {my jsonb
> fields}} which then gets passed into a template - don't want to have to
> keep using  <%= article.data.name  %>  instead of just data.name

Can you show us your SELECT?

>
> probably easy but can't find out how - any suggestions?
>
> ps: using new pg very lite orm library massive.js  (npm massive) - easy
> to run direct sql commands - very nice.
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Charles Clavadetscher
Date:
Subject: Re: String match function required like utl_match in oracle
Next
From: Filipe Pina
Date:
Subject: Re: database-level lockdown