目录

pg_ts_config

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

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

pg_ts_config 在 PostgreSQL 8.3 中被添加。

按 PostgreSQL 版本定义

pg_ts_config (PostgreSQL 19)

           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 18)

           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 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”的任何评论、建议或更正，请 在此处。