PostgreSQL: Documentation: 10: Chapter 12. Full Text Search

13th February 2020: PostgreSQL 12.2, 11.7, 10.12, 9.6.17, 9.5.21, and 9.4.26 Released!

Documentation → PostgreSQL 10

Supported Versions: Current (12) / 11 / 10 / 9.6 / 9.5

Development Versions: devel

Unsupported versions: 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3

Chapter 12. Full Text Search
Prev	Up	Part II. The SQL Language	Home	Next

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

Prev	Up	Next
11.12. Examining Index Usage	Home	12.1. Introduction

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.