PostgreSQL – Full Text Search – Day 1

Background Let us play with Full Text Search against our PostgreSQL table. Table Query Traditional Query Find Verses :- Jesus and Peter SQL Output Full Text Query Find Verses :- Jesus and Peter Outline to_tsvector([column-name]) to_tsvector(verse) to_tsquery Syntax :- to_tsquery([operand]) Sample :- to_tsquery('(Jesus & Peter)')) SQL Output ' Query Plan Indexes Functional indexes can be … Continue reading PostgreSQL – Full Text Search – Day 1