Contents

pg_ts_parser

A system table defining full text search parsers

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 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.

Examples

postgres=# \d pg_ts_parser
             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)

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

Categories

Full Text Search, System catalogue

See also

pg_ts_parser_is_visible(), pg_ts_config, pg_ts_config_map, pg_ts_dict, pg_ts_template