Re: How to search a string inside a json structure

["Jason O'Donnell" <odonnelljp01@xxxxxxxxx>]

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.pietila@xxxxxxxxx> 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