Easy, you need to extract text fields from json and construct tsvector from them (use concatenation, for example). On Tue, May 13, 2014 at 7:38 PM, Jesus Rafael Sanchez Medrano <jesusrafael@xxxxxxxxx> wrote: > can postgres do FTS (full text search) on a json column? if possible, please > be so kindd to give some snippet/example. > > > Att. > == > Jesus Rafael Sanchez Medrano > "Life is a dream, of which all must wake up"