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.

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

Columns 6

ColumnTypeDescription / reference
oidoidRow identifier
dictnamenameText search dictionary name
dictnamespaceoidThe OID of the namespace that contains this dictionary
pg_namespace.oid
dictowneroidOwner of the dictionary
pg_authid.oid
dicttemplateoidThe 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. PG 11 → 12changed
  2. PG 9.2 → 9.3changed

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