Contents

pg_ts_config

A system table storing information about full text search configuration

pg_ts_config is a system catalogue table storing information about full text search configuration.

pg_ts_config was added in PostgreSQL 8.3.

Definition by PostgreSQL version

pg_ts_config (PostgreSQL 14)

           Table "pg_catalog.pg_ts_config"
    Column    | Type | Collation | Nullable | Default 
--------------+------+-----------+----------+---------
 oid          | oid  |           | not null | 
 cfgname      | name |           | not null | 
 cfgnamespace | oid  |           | not null | 
 cfgowner     | oid  |           | not null | 
 cfgparser    | oid  |           | not null | 
Indexes:
    "pg_ts_config_oid_index" PRIMARY KEY, btree (oid)
    "pg_ts_config_cfgname_index" UNIQUE CONSTRAINT, btree (cfgname, cfgnamespace)

Documentation: pg_ts_config

pg_ts_config (PostgreSQL 13)

           Table "pg_catalog.pg_ts_config"
    Column    | Type | Collation | Nullable | Default 
--------------+------+-----------+----------+---------
 oid          | oid  |           | not null | 
 cfgname      | name |           | not null | 
 cfgnamespace | oid  |           | not null | 
 cfgowner     | oid  |           | not null | 
 cfgparser    | oid  |           | not null | 
Indexes:
    "pg_ts_config_cfgname_index" UNIQUE, btree (cfgname, cfgnamespace)
    "pg_ts_config_oid_index" UNIQUE, btree (oid)

Documentation: pg_ts_config

pg_ts_config (PostgreSQL 12)

           Table "pg_catalog.pg_ts_config"
    Column    | Type | Collation | Nullable | Default 
--------------+------+-----------+----------+---------
 oid          | oid  |           | not null | 
 cfgname      | name |           | not null | 
 cfgnamespace | oid  |           | not null | 
 cfgowner     | oid  |           | not null | 
 cfgparser    | oid  |           | not null | 
Indexes:
    "pg_ts_config_cfgname_index" UNIQUE, btree (cfgname, cfgnamespace)
    "pg_ts_config_oid_index" UNIQUE, btree (oid)

Documentation: pg_ts_config

pg_ts_config (PostgreSQL 11)

           Table "pg_catalog.pg_ts_config"
    Column    | Type | Collation | Nullable | Default 
--------------+------+-----------+----------+---------
 cfgname      | name |           | not null | 
 cfgnamespace | oid  |           | not null | 
 cfgowner     | oid  |           | not null | 
 cfgparser    | oid  |           | not null | 
Indexes:
    "pg_ts_config_cfgname_index" UNIQUE, btree (cfgname, cfgnamespace)
    "pg_ts_config_oid_index" UNIQUE, btree (oid)

Documentation: pg_ts_config

pg_ts_config (PostgreSQL 10)

           Table "pg_catalog.pg_ts_config"
    Column    | Type | Collation | Nullable | Default 
--------------+------+-----------+----------+---------
 cfgname      | name |           | not null | 
 cfgnamespace | oid  |           | not null | 
 cfgowner     | oid  |           | not null | 
 cfgparser    | oid  |           | not null | 
Indexes:
    "pg_ts_config_cfgname_index" UNIQUE, btree (cfgname, cfgnamespace)
    "pg_ts_config_oid_index" UNIQUE, btree (oid)

Documentation: pg_ts_config

pg_ts_config (PostgreSQL 9.6)

 Table "pg_catalog.pg_ts_config"
    Column    | Type | Modifiers 
--------------+------+-----------
 cfgname      | name | not null
 cfgnamespace | oid  | not null
 cfgowner     | oid  | not null
 cfgparser    | oid  | not null
Indexes:
    "pg_ts_config_cfgname_index" UNIQUE, btree (cfgname, cfgnamespace)
    "pg_ts_config_oid_index" UNIQUE, btree (oid)

Documentation: pg_ts_config

pg_ts_config (PostgreSQL 9.5)

 Table "pg_catalog.pg_ts_config"
    Column    | Type | Modifiers 
--------------+------+-----------
 cfgname      | name | not null
 cfgnamespace | oid  | not null
 cfgowner     | oid  | not null
 cfgparser    | oid  | not null
Indexes:
    "pg_ts_config_cfgname_index" UNIQUE, btree (cfgname, cfgnamespace)
    "pg_ts_config_oid_index" UNIQUE, btree (oid)

Documentation: pg_ts_config

pg_ts_config (PostgreSQL 9.4)

 Table "pg_catalog.pg_ts_config"
    Column    | Type | Modifiers 
--------------+------+-----------
 cfgname      | name | not null
 cfgnamespace | oid  | not null
 cfgowner     | oid  | not null
 cfgparser    | oid  | not null
Indexes:
    "pg_ts_config_cfgname_index" UNIQUE, btree (cfgname, cfgnamespace)
    "pg_ts_config_oid_index" UNIQUE, btree (oid)

Documentation: pg_ts_config

pg_ts_config (PostgreSQL 9.3)

 Table "pg_catalog.pg_ts_config"
    Column    | Type | Modifiers 
--------------+------+-----------
 cfgname      | name | not null
 cfgnamespace | oid  | not null
 cfgowner     | oid  | not null
 cfgparser    | oid  | not null
Indexes:
    "pg_ts_config_cfgname_index" UNIQUE, btree (cfgname, cfgnamespace)
    "pg_ts_config_oid_index" UNIQUE, btree (oid)

Documentation: pg_ts_config

pg_ts_config (PostgreSQL 9.2)

 Table "pg_catalog.pg_ts_config"
    Column    | Type | Modifiers 
--------------+------+-----------
 cfgname      | name | not null
 cfgnamespace | oid  | not null
 cfgowner     | oid  | not null
 cfgparser    | oid  | not null
Indexes:
    "pg_ts_config_cfgname_index" UNIQUE, btree (cfgname, cfgnamespace)
    "pg_ts_config_oid_index" UNIQUE, btree (oid)

Documentation: pg_ts_config

pg_ts_config (PostgreSQL 9.1)

 Table "pg_catalog.pg_ts_config"
    Column    | Type | Modifiers 
--------------+------+-----------
 cfgname      | name | not null
 cfgnamespace | oid  | not null
 cfgowner     | oid  | not null
 cfgparser    | oid  | not null
Indexes:
    "pg_ts_config_cfgname_index" UNIQUE, btree (cfgname, cfgnamespace)
    "pg_ts_config_oid_index" UNIQUE, btree (oid)

Documentation: pg_ts_config

pg_ts_config (PostgreSQL 9.0)

 Table "pg_catalog.pg_ts_config"
    Column    | Type | Modifiers 
--------------+------+-----------
 cfgname      | name | not null
 cfgnamespace | oid  | not null
 cfgowner     | oid  | not null
 cfgparser    | oid  | not null
Indexes:
    "pg_ts_config_cfgname_index" UNIQUE, btree (cfgname, cfgnamespace)
    "pg_ts_config_oid_index" UNIQUE, btree (oid)

Documentation: pg_ts_config

pg_ts_config (PostgreSQL 8.4)

 Table "pg_catalog.pg_ts_config"
    Column    | Type | Modifiers 
--------------+------+-----------
 cfgname      | name | not null
 cfgnamespace | oid  | not null
 cfgowner     | oid  | not null
 cfgparser    | oid  | not null
Indexes:
    "pg_ts_config_cfgname_index" UNIQUE, btree (cfgname, cfgnamespace)
    "pg_ts_config_oid_index" UNIQUE, btree (oid)

Documentation: pg_ts_config

pg_ts_config (PostgreSQL 8.3)

 Table "pg_catalog.pg_ts_config"
    Column    | Type | Modifiers 
--------------+------+-----------
 cfgname      | name | not null
 cfgnamespace | oid  | not null
 cfgowner     | oid  | not null
 cfgparser    | oid  | not null
Indexes:
    "pg_ts_config_cfgname_index" UNIQUE, btree (cfgname, cfgnamespace)
    "pg_ts_config_oid_index" UNIQUE, btree (oid)

Documentation: pg_ts_config

Change history

This table has not been modifed since it was added in PostgreSQL 8.3.

Examples

postgres=# \d pg_ts_config
           Table "pg_catalog.pg_ts_config"
    Column    | Type | Collation | Nullable | Default 
--------------+------+-----------+----------+---------
 oid          | oid  |           | not null | 
 cfgname      | name |           | not null | 
 cfgnamespace | oid  |           | not null | 
 cfgowner     | oid  |           | not null | 
 cfgparser    | oid  |           | not null | 
Indexes:
    "pg_ts_config_cfgname_index" UNIQUE, btree (cfgname, cfgnamespace)
    "pg_ts_config_oid_index" UNIQUE, btree (oid)


postgres=# SELECT * FROM pg_ts_config WHERE cfgname IN ('simple', 'english', 'german');
  oid  | cfgname | cfgnamespace | cfgowner | cfgparser
-------+---------+--------------+----------+-----------
  3748 | simple  |           11 |       10 |      3722
 13258 | english |           11 |       10 |      3722
 13264 | german  |           11 |       10 |      3722
(3 rows)

Categories

Full Text Search, System catalogue

See also

pg_ts_config_is_visible(), pg_ts_config_map, pg_ts_dict, pg_ts_parser, pg_ts_template