Open navClose nav

Category: Engineering

Full Text Searching with Postgres

At Forestry, we use Postgres as our primary data store. In this article I’ll show you how we used tsvectorto improve searching for documents in the CMS. The tsvector Type Postgres has a data type called tsvector that is used for full text search. A tsvector value merges different variants of the same word and removes duplicates to create a sorted list of distinct words called lexemes. SELECT to_tsvector('pg_catalog.english', 'Never gonna give you up.