pg_ts_config
The pg_ts_config catalog contains entries representing text search configurations. A configuration specifies a particular text search parser and a list of dictionaries to use for each of the parser's output token types. The parser is shown in the pg_ts_config entry, but the token-to-dictionary mapping is defined by subsidiary entries in pg_ts_config_map. PostgreSQL's text search features are described at length in Chapter 12.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- kind
- catalog
- lang
- en
- measured attributes
- true
- metadata release
- 18.6
- runtime columns
- oid, cfgname, cfgnamespace, cfgowner, cfgparser
- runtime verified
- false
- source
- english-manual
Definition PG 18
The pg_ts_config catalog contains entries representing text search configurations. A configuration specifies a particular text search parser and a list of dictionaries to use for each of the parser's output token types. The parser is shown in the pg_ts_config entry, but the token-to-dictionary mapping is defined by subsidiary entries in pg_ts_config_map. PostgreSQL's text search features are described at length in Chapter 12.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| oid | oid | Not null | Row identifier |
| cfgname | name | Not null | Text search configuration name |
| cfgnamespace | oid | Not null | The OID of the namespace that contains this configuration |
| cfgowner | oid | Not null | Owner of the configuration |
| cfgparser | oid | Not null | The OID of the text search parser for this configuration |
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:39310c3a49891866fdbc41aa4904b597bd3956beef2fc1e4e3198c9b0e893c48
Text language: en · catalog-bilingual-repair:39310c3a49891866fdbc41aa4904b597bd3956beef2fc1e4e3198c9b0e893c48