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.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general