Navigation : PostgreSQL 17.2 Documentation > Chapter 12. Full Text Search Chapter 12. Full Text Search Chapter 12. Full Text Search Prev Up Part II. The SQL Language Home Next 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. Preferred Index Types for Text Search 12.10. psql Support 12.11. Limitations