↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Functions

to_tsquery

Converts text to a tsquery, normalizing words according to the specified or default configuration. The words must be combined by valid tsquery operators.

English manual coverage begins with PostgreSQL 7.1. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

group
textsearch
group label
文本搜索函数和操作符
lang
en
layout
table-new
pages
functions-textsearch.html
prose only
false

Definition PG 18

Converts text to a tsquery, normalizing words according to the specified or default configuration. The words must be combined by valid tsquery operators.

Signatures and overloads

to_tsquery ( [config regconfig, ] query text ) → tsquery → tsquery
Converts text to a tsquery, normalizing words according to the specified or default configuration. The words must be combined by valid tsquery operators.

Compare versions

Complete source facts

documentation revision

{"inputs":[{"file":"functions-textsearch.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"2383d74fd6eee4b71e1b97dec9754623081103120b67a9793f8deac5fff77727","version":"18.7"},{"file":"functions-textsearch.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"d8d1661c6d67bb109c5266be16236950471c11d91181aafa96e9055792c4fa78","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:5b43617acccbe36cb0b81f7f7d8c5ce5a32141663d47fa0ad035740b8dd668f7

Text language: en · wiki-repair-20261023:5b43617acccbe36cb0b81f7f7d8c5ce5a32141663d47fa0ad035740b8dd668f7