Documentation → PostgreSQL 9.2

Supported Versions: Current (17) / 16 / 15 / 14 / 13

Development Versions: devel

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

This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

PostgreSQL 9.2.24 Documentation
Prev	Up		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. GiST and GIN Index Types

12.10. psql Support

12.11. Limitations

12.12. Migration from Pre-8.3 Text Search

Prev	Home	Next
Examining Index Usage	Up	Introduction