Crunchy Data

    • PostgreSQL: The World's Most Advanced Open Source Relational Database
      Available Formats

    • Navigation
    • Home

    Navigation :
    PostgreSQL 14.18 Documentation > Chapter 12. Full Text Search

    Chapter 12. Full Text Search

    Chapter 12. Full Text Search
    Prev Up Part II. The SQL Language Home Next

    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. Preferred Index Types for Text Search
    12.10. psql Support
    12.11. Limitations

    Prev Up Next
    11.12. Examining Index Usage Home 12.1. Introduction