Many times it is difficult to find which table or tables some information is saved.

It involves searching documentation, debugging and looking at code.


This sql query is useful in this (at present the query is for postgres database)


SELECT ('select ' || column_name ||  ' from ' || table_name || ' where '||  column_name ||  ' like ''%?%''; ') 

FROM information_schema.columns c

WHERE c.table_name in (

SELECT table_name

FROM information_schema.tables where table_schema = 'public'

) and c.data_type='text'


This post of mine explains a simple solution DATABASE Blog


This is useful for developers who are new to jive and want to learn how the data gets stored and to debug in better informed way.