tsvector_update_trigger_column

Automatically updates a tsvector column from associated plain-text document column(s). The text search configuration to use is taken from a regconfig column of the table. See Section 12.4.3 for details.

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

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

group: trigger
group label: Trigger Functions
lang: en
layout: table-new
pages: functions-trigger.html
prose only: false

Definition PG 18

Automatically updates a tsvector column from associated plain-text document column(s). The text search configuration to use is taken from a regconfig column of the table. See Section 12.4.3 for details.

Signatures and overloads

tsvector_update_trigger_column ( ) → trigger → trigger

Compare versions

Source references

Original manual reference

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:42465f7cb16ae763888b41628854cbf656021133b79a6df52b7ff3a928ba6ef0

Text language: en · wiki-repair-20261023:42465f7cb16ae763888b41628854cbf656021133b79a6df52b7ff3a928ba6ef0