Re: How to search a string inside a json structure

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "sampie(at)iki(dot)fi" <sampie(at)iki(dot)fi>
Cc: Merlin Moncure <mmoncure(at)gmail(dot)com>, Vick Khera <vivek(at)khera(dot)org>, "Jason O'Donnell" <odonnelljp01(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to search a string inside a json structure
Date: 2015-11-07 15:48:27
Message-ID: CAKFQuwbwvPy4hQbDDorao+_eHd9U4fv0Ovi3DbM7MUquMqxBMQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Saturday, November 7, 2015, Sami Pietilä <sami(dot)pietila(at)gmail(dot)com> wrote:

> How can I rename the columns coming from jsonb_ functions? Or is there a
> better way of unpacking the list and items?
>

select * from function(...) [as] func-name_alias (col1_alias, col2_alias,
etc...)

David J.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tim Chou 2015-11-08 07:27:33 Error when test on DBT2 Postgresql
Previous Message Sami Pietilä 2015-11-07 07:27:05 Re: How to search a string inside a json structure