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 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)
Documentation: 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)
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.
- PostgreSQL 8.3
- (commit 140d4ebc)
Examples
Sample contents of 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)
References
- PostgreSQL documentation: pg_ts_config