How to search a string inside a json structure - Mailing list pgsql-general

From Sami Pietilä
Subject How to search a string inside a json structure
Date
Msg-id CAN08J2jQP3NN_dwOtO6BvbRE_jnBDRiOfsc73-4vHwdKRXUQtQ@mail.gmail.com
Whole thread Raw
Responses Re: How to search a string inside a json structure
List pgsql-general
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

pgsql-general by date:

Previous
From: Igor Bossenko
Date:
Subject: Re: Is there bigintarray?
Next
From: Jeff Janes
Date:
Subject: Re: Waiting on ExclusiveLock on extension 9.3, 9.4 and 9.5