Chapter 12. Full Text Search — PostgreSQL 13 | PG.CENTER

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Documentation → PostgreSQL 13

Supported versions: Current (18) / 17 / 16 / 15 / 14

Development versions: 19 / 20devel

Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3

Historical version. PostgreSQL 13 has reached end of support. 2025-11-13. See the current manual.

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. Preferred Index Types for Text Search

12.10. psql Support

12.11. Limitations

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

Report a documentation issue

Read the upstream documentation. For corrections, first check the current manual.