Re: How to search a string inside a json structure

Sami,

What version of postgres are you using?

There's some examples using GIN indexes for searching jsonb objects in the
wiki:
https://wiki.postgresql.org/wiki/What's_new_in_PostgreSQL_9.4#JSONB_Binary_JSON_storage

Hope that helps,

On Mon, Nov 2, 2015 at 4:09 PM, Sami Pietilä <sami(dot)pietila(at)gmail(dot)com> wrote:

> Hi,
>
> I have a database with jsonb type of columns. Colums contain complex json
> structures. I would like to get all rows which contain a json where any of
> json's values matches to a given string (like %hello%).
>
> How to create a postgre sql query to do this?
>
> I guess postgre should traverse though each json structures while finding
> the string.
>
> Thanks
>

--
Jason O'Donnell
Crunchy Data Solutions