---
title: "Full Text Search"
id: textsearch
pg_version: "20devel"
---

<a id="textsearch"></a>

# Full Text Search

## Table of Contents

- [12.1. Introduction](textsearch-intro.md)
  - [12.1.1. What Is a Document?](textsearch-intro.md#textsearch-document)
  - [12.1.2. Basic Text Matching](textsearch-intro.md#textsearch-matching)
  - [12.1.3. Configurations](textsearch-intro.md#textsearch-intro-configurations)
- [12.2. Tables and Indexes](textsearch-tables.md)
  - [12.2.1. Searching a Table](textsearch-tables.md#textsearch-tables-search)
  - [12.2.2. Creating Indexes](textsearch-tables.md#textsearch-tables-index)
- [12.3. Controlling Text Search](textsearch-controls.md)
  - [12.3.1. Parsing Documents](textsearch-controls.md#textsearch-parsing-documents)
  - [12.3.2. Parsing Queries](textsearch-controls.md#textsearch-parsing-queries)
  - [12.3.3. Ranking Search Results](textsearch-controls.md#textsearch-ranking)
  - [12.3.4. Highlighting Results](textsearch-controls.md#textsearch-headline)
- [12.4. Additional Features](textsearch-features.md)
  - [12.4.1. Manipulating Documents](textsearch-features.md#textsearch-manipulate-tsvector)
  - [12.4.2. Manipulating Queries](textsearch-features.md#textsearch-manipulate-tsquery)
  - [12.4.3. Triggers for Automatic Updates](textsearch-features.md#textsearch-update-triggers)
  - [12.4.4. Gathering Document Statistics](textsearch-features.md#textsearch-statistics)
- [12.5. Parsers](textsearch-parsers.md)
- [12.6. Dictionaries](textsearch-dictionaries.md)
  - [12.6.1. Stop Words](textsearch-dictionaries.md#textsearch-stopwords)
  - [12.6.2. Simple Dictionary](textsearch-dictionaries.md#textsearch-simple-dictionary)
  - [12.6.3. Synonym Dictionary](textsearch-dictionaries.md#textsearch-synonym-dictionary)
  - [12.6.4. Thesaurus Dictionary](textsearch-dictionaries.md#textsearch-thesaurus)
  - [12.6.5. Ispell Dictionary](textsearch-dictionaries.md#textsearch-ispell-dictionary)
  - [12.6.6. Snowball Dictionary](textsearch-dictionaries.md#textsearch-snowball-dictionary)
- [12.7. Configuration Example](textsearch-configuration.md)
- [12.8. Testing and Debugging Text Search](textsearch-debugging.md)
  - [12.8.1. Configuration Testing](textsearch-debugging.md#textsearch-configuration-testing)
  - [12.8.2. Parser Testing](textsearch-debugging.md#textsearch-parser-testing)
  - [12.8.3. Dictionary Testing](textsearch-debugging.md#textsearch-dictionary-testing)
- [12.9. Preferred Index Types for Text Search](textsearch-indexes.md)
- [12.10. psql Support](textsearch-psql.md)
- [12.11. Limitations](textsearch-limitations.md)