Skip to content
← Catalog atlas / pg_ts_config

SYSTEM CATALOG · System catalog

pg_ts_config

PostgreSQL documentation ↗Source definition ↗

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.

First seen PG 9.0Last seen PG 19Columns 5
9.09.19.29.39.49.59.610111213141516171819β3

Checked column by column against a PostgreSQL 18.6 instance · Raw measurement record ↗

Columns PostgreSQL 18

pg_ts_config
COLUMNTYPEDESCRIPTION
oid oidNOT NULL Row identifier
cfgname nameNOT NULL Text search configuration name
cfgnamespace oidNOT NULL The OID of the namespace that contains this configurationReferences:pg_namespace.oid
cfgowner oidNOT NULL Owner of the configurationReferences:pg_authid.oid
cfgparser oidNOT NULL The OID of the text search parser for this configurationReferences:pg_ts_parser.oid

Columns marked "implicit" are not included in SELECT *; some early statistics views are completed from same-version source, and the extra provenance is shown in the column description.

Common system columns 6

System attributes PostgreSQL provides, normally not expanded by SELECT *. Kept separately so they are not mixed in with ordinary columns.

ColumnsTypeattnum
tableoidoid-6
cmaxcid-5
xmaxxid-4
cmincid-3
xminxid-2
ctidtid-1

Column evolution matrix

Hover a cell for the column type
PresentAdded / type or attribute changeRemoved
COLUMN9.09.19.29.39.49.59.610111213141516171819
oid
cfgname
cfgnamespace
cfgowner
cfgparser

9.0 is the coverage baseline; a column already present in the baseline is not marked as added. The matrix aligns columns by name, so a rename appears as the old column removed and a new column added.

Evolution timeline

Changes between adjacent majors

PostgreSQL 12 ← 11

~ oid: implicit → ordinary1 column description updates

PostgreSQL 9.3 ← 9.2

1 column description updates

Compare any two versions

Pick two versions to see added, removed, and retyped columns. The interactive comparison needs JavaScript; the evolution timeline reads fine without it.