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