Chapter 12. Full Text Search

Table of Contents

12.1. Introduction : 12.1.1. What Is a 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 : 12.2.1. Searching a Table

[12.2.2. Creating Indexes](textsearch-tables.md#TEXTSEARCH-TABLES-INDEX)

12.3. Controlling Text Search : 12.3.1. 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 : 12.4.1. Manipulating Documents

[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

12.6. Dictionaries : 12.6.1. Stop Words

[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

12.8. Testing and Debugging Text Search : 12.8.1. 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. GIN and GiST Index Types

12.10. psql Support

12.11. Limitations