Home
About
Download
Documentation
Community
Developers
Support
Donate
Your account
August 8th, 2024:
PostgreSQL 16.4, 15.8, 14.13, 13.16, 12.20, and 17 Beta 3 Released!
Documentation
→
PostgreSQL 9.5
Supported Versions:
Current
(
16
) /
15
/
14
/
13
/
12
Development Versions:
17
/
devel
Unsupported versions:
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.5.25 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.
GIN and GiST 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