Full-Text Search with tsvector and GIN
Build production full-text search with tsvector columns, GIN indexes, and configurable text-search dictionaries.
Beyond Substring: Word-Aware Search
Full-text search (FTS) understands words: stemming, stop words, ranking. PostgreSQL has it built in via the tsvector / tsquery types.
Build a tsvector
Parse a document:
SELECT to_tsvector('english', 'The quick brown foxes jumped over');
-- 'brown':3 'fox':4 'jump':5 'quick':2All lessons in this course
- Trigram Search (pg_trgm) for Fuzzy Matching
- Full-Text Search with tsvector and GIN
- Geospatial Indexing with PostGIS
- Vector Search with pgvector