Full-Text Search in PostgreSQL

A Gentle Introduction

Oleg Bartunov

Moscow University


Moscow
Russia

Teodor Sigaev

Moscow University


Moscow
Russia

This document is OBSOLETE ! Read an official documentation instead.


Table of Contents
1. FTS Introduction
1.1. Full Text Search in databases
1.2. FTS Overview
1.3. Basic operations
1.4. FTS features
1.5. FTS Limitations
1.6. A Brief History of FTS in PostgreSQL
1.7. Links
1.8. FTS Todo
1.9. Acknowledgements
2. FTS Operators and Functions
2.1. FTS operator
2.2. Vector Operations
2.3. Query Operations
2.4. Parser functions
2.5. Ranking
2.6. Headline
2.7. Full-text indexes
2.8. Dictionaries
2.9. FTS Configuration
2.10. Debugging
2.11. Psql support
I. FTS Reference
I. SQL Commands
II. Appendixes
A. FTS Complete Tutorial
B. FTS Parser Example
C. FTS Dictionary Example
Index