Chapter 12. Full Text Search

Table of Contents

12.1. Introduction

12.1.1. What Is a Document?

12.1.2. Basic Text Matching

12.1.3. Configurations

12.2. Tables and Indexes

12.2.1. Searching a Table

12.2.2. Creating Indexes

12.3. Controlling Text Search

12.3.1. Parsing Documents

12.3.2. Parsing Queries

12.3.3. Ranking Search Results

12.3.4. Highlighting Results

12.4. Additional Features

12.4.1. Manipulating Documents

12.4.2. Manipulating Queries

12.4.3. Triggers for Automatic Updates

12.4.4. Gathering Document Statistics

12.5. Parsers

12.6. Dictionaries

12.6.1. Stop Words

12.6.2. Simple Dictionary

12.6.3. Synonym Dictionary

12.6.4. Thesaurus Dictionary

12.6.5. Ispell Dictionary

12.6.6. Snowball Dictionary

12.7. Configuration Example

12.8. Testing and Debugging Text Search

12.8.1. Configuration Testing

12.8.2. Parser Testing

12.8.3. Dictionary Testing

12.9. GIN and GiST Index Types

12.10. psql Support

12.11. Limitations