Thread: return jsonb without field label

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

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.

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