Search text
Match text with patterns and supported text-search functions.
Example
Section titled “Example”CREATE TABLE docs_text (id BIGINT PRIMARY KEY, title TEXT);INSERT INTO docs_text VALUES (1, 'Database guide'), (2, 'API reference');SELECT id, title FROM docs_text WHERE title ILIKE '%database%';SELECT to_tsvector('english', 'The quick fox') @@ to_tsquery('english', 'fox') AS matches;Behavior
Section titled “Behavior”Pattern matching and word search have different semantics. Neither is vector similarity search. Test tokenization, language handling and index use on your own data. A parser accepting an index declaration does not prove that a particular query uses that index.
Related
Section titled “Related”This site uses Google Analytics cookies to count visits. Privacy · License