目录

pg_ts_config

存储有关全文搜索配置信息的系统表

pg_ts_config 是一个存储有关全文搜索配置信息的系统目录表。

pg_ts_config 在PostgreSQL 8.3中添加。

按 PostgreSQL 版本定义

pg_ts_config (PostgreSQL 17)

           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)

文档: pg_ts_config

pg_ts_config (PostgreSQL 16)

           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)

文档: pg_ts_config

pg_ts_config (PostgreSQL 15)

           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)

文档: pg_ts_config

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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: pg_ts_config

更改历史记录

自PostgreSQL 8.3中添加以来，此表未被修改。

示例

pg_ts_config 的示例内容

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)

分类

全文搜索，系统目录

另请参阅

pg_ts_config_is_visible()，pg_ts_config_map，pg_ts_dict，pg_ts_parser，pg_ts_template

反馈

提交您对 "pg_ts_config" 的任何评论、建议或更正 此处。