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.piet...@gmail.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
