pg_ts_parser
pg_ts_parser
is a system catalogue table defining full text search parsers.
pg_ts_parser
was added in PostgreSQL 8.3.
Definition by PostgreSQL version
pg_ts_parser (PostgreSQL 16)
Table "pg_catalog.pg_ts_parser" Column | Type | Collation | Nullable | Default --------------+---------+-----------+----------+--------- oid | oid | | not null | prsname | name | | not null | prsnamespace | oid | | not null | prsstart | regproc | | not null | prstoken | regproc | | not null | prsend | regproc | | not null | prsheadline | regproc | | not null | prslextype | regproc | | not null | Indexes: "pg_ts_parser_oid_index" PRIMARY KEY, btree (oid) "pg_ts_parser_prsname_index" UNIQUE CONSTRAINT, btree (prsname, prsnamespace)
Documentation: pg_ts_parser
pg_ts_parser (PostgreSQL 15)
Table "pg_catalog.pg_ts_parser" Column | Type | Collation | Nullable | Default --------------+---------+-----------+----------+--------- oid | oid | | not null | prsname | name | | not null | prsnamespace | oid | | not null | prsstart | regproc | | not null | prstoken | regproc | | not null | prsend | regproc | | not null | prsheadline | regproc | | not null | prslextype | regproc | | not null | Indexes: "pg_ts_parser_oid_index" PRIMARY KEY, btree (oid) "pg_ts_parser_prsname_index" UNIQUE CONSTRAINT, btree (prsname, prsnamespace)
Documentation: pg_ts_parser
pg_ts_parser (PostgreSQL 14)
Table "pg_catalog.pg_ts_parser" Column | Type | Collation | Nullable | Default --------------+---------+-----------+----------+--------- oid | oid | | not null | prsname | name | | not null | prsnamespace | oid | | not null | prsstart | regproc | | not null | prstoken | regproc | | not null | prsend | regproc | | not null | prsheadline | regproc | | not null | prslextype | regproc | | not null | Indexes: "pg_ts_parser_oid_index" PRIMARY KEY, btree (oid) "pg_ts_parser_prsname_index" UNIQUE CONSTRAINT, btree (prsname, prsnamespace)
Documentation: pg_ts_parser
pg_ts_parser (PostgreSQL 13)
Table "pg_catalog.pg_ts_parser" Column | Type | Collation | Nullable | Default --------------+---------+-----------+----------+--------- oid | oid | | not null | prsname | name | | not null | prsnamespace | oid | | not null | prsstart | regproc | | not null | prstoken | regproc | | not null | prsend | regproc | | not null | prsheadline | regproc | | not null | prslextype | regproc | | not null | Indexes: "pg_ts_parser_oid_index" UNIQUE, btree (oid) "pg_ts_parser_prsname_index" UNIQUE, btree (prsname, prsnamespace)
Documentation: pg_ts_parser
pg_ts_parser (PostgreSQL 12)
Table "pg_catalog.pg_ts_parser" Column | Type | Collation | Nullable | Default --------------+---------+-----------+----------+--------- oid | oid | | not null | prsname | name | | not null | prsnamespace | oid | | not null | prsstart | regproc | | not null | prstoken | regproc | | not null | prsend | regproc | | not null | prsheadline | regproc | | not null | prslextype | regproc | | not null | Indexes: "pg_ts_parser_oid_index" UNIQUE, btree (oid) "pg_ts_parser_prsname_index" UNIQUE, btree (prsname, prsnamespace)
Documentation: pg_ts_parser
pg_ts_parser (PostgreSQL 11)
Table "pg_catalog.pg_ts_parser" Column | Type | Collation | Nullable | Default --------------+---------+-----------+----------+--------- prsname | name | | not null | prsnamespace | oid | | not null | prsstart | regproc | | not null | prstoken | regproc | | not null | prsend | regproc | | not null | prsheadline | regproc | | not null | prslextype | regproc | | not null | Indexes: "pg_ts_parser_oid_index" UNIQUE, btree (oid) "pg_ts_parser_prsname_index" UNIQUE, btree (prsname, prsnamespace)
Documentation: pg_ts_parser
pg_ts_parser (PostgreSQL 10)
Table "pg_catalog.pg_ts_parser" Column | Type | Collation | Nullable | Default --------------+---------+-----------+----------+--------- prsname | name | | not null | prsnamespace | oid | | not null | prsstart | regproc | | not null | prstoken | regproc | | not null | prsend | regproc | | not null | prsheadline | regproc | | not null | prslextype | regproc | | not null | Indexes: "pg_ts_parser_oid_index" UNIQUE, btree (oid) "pg_ts_parser_prsname_index" UNIQUE, btree (prsname, prsnamespace)
Documentation: pg_ts_parser
pg_ts_parser (PostgreSQL 9.6)
Table "pg_catalog.pg_ts_parser" Column | Type | Modifiers --------------+---------+----------- prsname | name | not null prsnamespace | oid | not null prsstart | regproc | not null prstoken | regproc | not null prsend | regproc | not null prsheadline | regproc | not null prslextype | regproc | not null Indexes: "pg_ts_parser_oid_index" UNIQUE, btree (oid) "pg_ts_parser_prsname_index" UNIQUE, btree (prsname, prsnamespace)
Documentation: pg_ts_parser
pg_ts_parser (PostgreSQL 9.5)
Table "pg_catalog.pg_ts_parser" Column | Type | Modifiers --------------+---------+----------- prsname | name | not null prsnamespace | oid | not null prsstart | regproc | not null prstoken | regproc | not null prsend | regproc | not null prsheadline | regproc | not null prslextype | regproc | not null Indexes: "pg_ts_parser_oid_index" UNIQUE, btree (oid) "pg_ts_parser_prsname_index" UNIQUE, btree (prsname, prsnamespace)
Documentation: pg_ts_parser
pg_ts_parser (PostgreSQL 9.4)
Table "pg_catalog.pg_ts_parser" Column | Type | Modifiers --------------+---------+----------- prsname | name | not null prsnamespace | oid | not null prsstart | regproc | not null prstoken | regproc | not null prsend | regproc | not null prsheadline | regproc | not null prslextype | regproc | not null Indexes: "pg_ts_parser_oid_index" UNIQUE, btree (oid) "pg_ts_parser_prsname_index" UNIQUE, btree (prsname, prsnamespace)
Documentation: pg_ts_parser
pg_ts_parser (PostgreSQL 9.3)
Table "pg_catalog.pg_ts_parser" Column | Type | Modifiers --------------+---------+----------- prsname | name | not null prsnamespace | oid | not null prsstart | regproc | not null prstoken | regproc | not null prsend | regproc | not null prsheadline | regproc | not null prslextype | regproc | not null Indexes: "pg_ts_parser_oid_index" UNIQUE, btree (oid) "pg_ts_parser_prsname_index" UNIQUE, btree (prsname, prsnamespace)
Documentation: pg_ts_parser
pg_ts_parser (PostgreSQL 9.2)
Table "pg_catalog.pg_ts_parser" Column | Type | Modifiers --------------+---------+----------- prsname | name | not null prsnamespace | oid | not null prsstart | regproc | not null prstoken | regproc | not null prsend | regproc | not null prsheadline | regproc | not null prslextype | regproc | not null Indexes: "pg_ts_parser_oid_index" UNIQUE, btree (oid) "pg_ts_parser_prsname_index" UNIQUE, btree (prsname, prsnamespace)
Documentation: pg_ts_parser
pg_ts_parser (PostgreSQL 9.1)
Table "pg_catalog.pg_ts_parser" Column | Type | Modifiers --------------+---------+----------- prsname | name | not null prsnamespace | oid | not null prsstart | regproc | not null prstoken | regproc | not null prsend | regproc | not null prsheadline | regproc | not null prslextype | regproc | not null Indexes: "pg_ts_parser_oid_index" UNIQUE, btree (oid) "pg_ts_parser_prsname_index" UNIQUE, btree (prsname, prsnamespace)
Documentation: pg_ts_parser
pg_ts_parser (PostgreSQL 9.0)
Table "pg_catalog.pg_ts_parser" Column | Type | Modifiers --------------+---------+----------- prsname | name | not null prsnamespace | oid | not null prsstart | regproc | not null prstoken | regproc | not null prsend | regproc | not null prsheadline | regproc | not null prslextype | regproc | not null Indexes: "pg_ts_parser_oid_index" UNIQUE, btree (oid) "pg_ts_parser_prsname_index" UNIQUE, btree (prsname, prsnamespace)
Documentation: pg_ts_parser
pg_ts_parser (PostgreSQL 8.4)
Table "pg_catalog.pg_ts_parser" Column | Type | Modifiers --------------+---------+----------- prsname | name | not null prsnamespace | oid | not null prsstart | regproc | not null prstoken | regproc | not null prsend | regproc | not null prsheadline | regproc | not null prslextype | regproc | not null Indexes: "pg_ts_parser_oid_index" UNIQUE, btree (oid) "pg_ts_parser_prsname_index" UNIQUE, btree (prsname, prsnamespace)
Documentation: pg_ts_parser
pg_ts_parser (PostgreSQL 8.3)
Table "pg_catalog.pg_ts_parser" Column | Type | Modifiers --------------+---------+----------- prsname | name | not null prsnamespace | oid | not null prsstart | regproc | not null prstoken | regproc | not null prsend | regproc | not null prsheadline | regproc | not null prslextype | regproc | not null Indexes: "pg_ts_parser_oid_index" UNIQUE, btree (oid) "pg_ts_parser_prsname_index" UNIQUE, btree (prsname, prsnamespace)
Documentation: pg_ts_parser
Change history
This table has not been modified since it was added in PostgreSQL 8.3.
- PostgreSQL 8.3
- added (commit 140d4ebc)
Examples
Typical contents of pg_ts_parser
:
postgres=# SELECT * from pg_ts_parser\gx -[ RECORD 1 ]+--------------- oid | 3722 prsname | default prsnamespace | 11 prsstart | prsd_start prstoken | prsd_nexttoken prsend | prsd_end prsheadline | prsd_headline prslextype | prsd_lextype
References
- PostgreSQL documentation: pg_ts_parser