Indexing binary data in PostgreSQL?
Oracle text search filter is capable of automatically parsing non-plain text documents, such as MS Word or PDF, while Postgres' text search can only handle plain text documents. You'll have to convert whatever is stored in your BLOB column to plain text before loading those data into a Postgres TEXT column, then build the Postgres text search index on that.