| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | "john(dot)tiger" <john(dot)tigernassau(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: return jsonb without field label |
| Date: | 2015-07-04 13:21:19 |
| Message-ID: | 5597DDCF.2060605@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Filipe Pina | 2015-07-04 17:49:23 | Re: database-level lockdown |
| Previous Message | Charles Clavadetscher | 2015-07-04 10:21:31 | Re: String match function required like utl_match in oracle |