to_tsvector ( [config regconfig, ] document text ) → tsvector → tsvectorConverts text to a
tsvector, normalizing words according to the specified or default configuration. Position information is included in the result.to_tsvector
Converts text to a tsvector, normalizing words according to the specified or default configuration. Position information is included in the result.
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
tsvector, normalizing words according to the specified or default configuration. Position information is included in the result.Signatures and overloads
to_tsvector ( [config regconfig, ] document json ) → tsvector → tsvectorConverts each string value in the JSON document to a
tsvector, normalizing words according to the specified or default configuration. The results are then concatenated in document order to produce the output. Position information is generated as though one stopword exists between each pair of string values. (Beware that “document order” of the fields of a JSON object is implementation-dependent when the input is jsonb; observe the difference in the examples.)to_tsvector ( [config regconfig, ] document jsonb ) → tsvector → tsvectorConverts each string value in the JSON document to a
tsvector, normalizing words according to the specified or default configuration. The results are then concatenated in document order to produce the output. Position information is generated as though one stopword exists between each pair of string values. (Beware that “document order” of the fields of a JSON object is implementation-dependent when the input is jsonb; observe the difference in the examples.)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:2385db438fe92aff1cf970e38f080667495eae500898882d61167cdd2227f70a
Text language: en · wiki-repair-20261023:2385db438fe92aff1cf970e38f080667495eae500898882d61167cdd2227f70a