EnterpriseDB
  • Home
  • Category
    Installation & Getting Started Quick Start Reference User Guides
  • Product
    EDB Backup and Recovery Tool EDB JDBC Connector EDB .NET Connector EDB OCL Connector EDB ODBC Connector EDB*Plus EDB Postgres Advanced Server EDB Postgres Ark Platform EDB Postgres Cloud Database Service EDB Postgres Enterprise Manager EDB Postgres Failover Manager EDB Postgres Hadoop Foreign Data Wrapper EDB Postgres Language Pack EDB Postgres Migration Portal EDB Postgres Migration Toolkit EDB Postgres MongoDB Foreign Data Wrapper EDB Postgres MySQL Foreign Data Wrapper EDB Postgres PgBouncer EDB Postgres Pgpool-II EDB Postgres PostGIS EDB Postgres Replication Server EDB Postgres Slony Replication PostgreSQL pgAdmin 4

PostgreSQL → 13.1 → Reference → Manual
Other versions of this page: 13.1 · 13.0 · 12.5 · 12.4 · 12.3 · 12.2 · 12.1 · 12.0 · 11.10 · 11.9 · 11.8 · 11.7 · 11.6 · 11.5 · 11.4 · 11.3 · 11.2 · 11.1 · 11.0 · 10.15 · 10.14 · 10.13 · 10.12 · 10.11 · 10.10 · 10.9 · 10.8 · 10.7 · 9.6.20 · 9.6.19 · 9.6.18 · 9.6.17 · 9.6.16 · 9.6.15 · 9.6.14 · 9.6.13 · 9.6.12 · 9.5.24 · 9.5.23 · 9.5.22 · 9.5.21 · 9.5.20 · 9.5.19 · 9.5.18 · 9.5.17 · 9.5.16 · 9.4.26 · 9.4.25 · 9.4.24 · 9.4.23 · 9.4.22 · 9.4.21

Get Postgres Tips and Tricks

Subscribe to get advanced Postgres how-tos.

Chapter 12. Full Text Search
Prev UpPart II. The SQL LanguageHome 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

Prev Up Next
11.12. Examining Index Usage Home 12.1. Introduction
© 2021 EnterpriseDB Corporation. All rights reserved. | Privacy Policy | Terms of Use | Trademarks