Functions / Text Search Functions And Operators

phraseto_tsquery

Converts text to a tsquery, normalizing words according to the specified or default configuration.

Reading PG 18current·documented in 12 of 27 versions, 9.6 to 20

7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Signatures & examples

phraseto_tsquery ( [ config regconfig, ] query text ) → tsquery

Converts text to a tsquery, normalizing words according to the specified or default configuration. Any punctuation in the string is ignored (it does not determine query operators). The resulting query matches phrases containing all non-stopwords in the text.

phraseto_tsquery('english', 'The Fat Rats') → 'fat' <-> 'rat'

phraseto_tsquery('english', 'The Cat and Rats') → 'cat' <2> 'rat'

Version history 2

12 → 13 changed
9.5 → 9.6 added

Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source