Full-Field Search

Efficiently Implementing Full-table and Full-field Fuzzy Search in Milliseconds with PostgreSQL

This article describes how to perform fuzzy searches for all the fields in a table using pg_trgm. It illustrates the implementation of a full-table and full-field fuzzy search with an example.

PostgreSQL Row-Level Full-Text Search

This article looks at row-level full-text searches in PostgreSQL and walks through how you can create one yourself.