↑↓ select ↵ open ⌫ change scope Open full search

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

System Catalogs / System catalogs

The pg_ts_dict catalog contains entries defining text search dictionaries.

Reading PG 18current·documented in 20 of 24 versions, 8.3 to 20

Kind
System catalogs
Columns in this snapshot
6
Definition source
English manual
Metadata snapshot
18.6

Columns 6

As listed in the PostgreSQL 18 manual.

ColumnTypeDescription / reference
oidoidNOT NULLRow identifier
dictnamenameNOT NULLText search dictionary name
dictnamespaceoidNOT NULLThe OID of the namespace that contains this dictionary
pg_namespace.oid
dictowneroidNOT NULLOwner of the dictionary
pg_authid.oid
dicttemplateoidNOT NULLThe OID of the text search template for this dictionary
pg_ts_template.oid
dictinitoptiontextInitialization option string for the template
Column history across versions
Version history 2
  1. 11 → 12 changed
  2. 8.2 → 8.3 added

Definition snapshot: english-manuals:e14de45cb1f0ea1e4f13bdd47d1… · English manual source